New answers tagged serialization
A READ ONLY transaction cannot cause a write transaction (that does not perform DDL) to fail, unless it explicitly uses LOCK TABLE or advisory locks. READ ONLY transactions cannot SELECT ... FOR SHARE or SELECT ... FOR UPDATE. As they can't do DML, the strongest lock they can take on a table is ACCESS SHARE, which conflicts only with the ACCESS EXCLUSIVE ...
There is no actual serial data type. serial is just a notational convenience. The resulting data type is integer for serial or bigint for bigserial Related answer on SO with more details: Auto increment SQL function You'd have to be more specific for a more specific answer.
Top 50 recent answers are included