"Bright D.L." <[EMAIL PROTECTED]> writes: > P1 did commit its insertion and verified it by successfully querying the > last inserted data, before sending the TCP packet - the trigger - to P2
The fact that P1 can see data it inserted is no proof at all that it's committed its transaction. I think you've somehow messed up the commit step. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general