Scot Kreienkamp wrote: > I have a table like so: > > Receiptlimitid: BIGINT (Primary Key) > Profitcenterid: BIGINT > Receiptnumber: INTEGER > > All are set to Not Null also. > > > My question is, if I have an insert that goes idle in transaction for a while > before it commits, will > it stop all other inserts from happening on the table? If so, is that > because of the possible > violation of the primary key by the following pending inserts? Just trying > to confirm the behavior > I'm seeing and make sure I understand what's going on.
Other INSERTs shouldn't be blocked unless you try to insert a record with the same primary key as the one in the open transaction. If you experience any such problems, check pg_locks for what's going on. Are there any foreign keys involved? Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
