"Bright D.L." <dl_bright@xxxxxxxxxxxxxx> 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