"Bright D.L." <dl_bright@star-quest.com> 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