Re: SELECT Query returns empty - Mailing list pgsql-general

From Tom Lane
Subject Re: SELECT Query returns empty
Date
Msg-id 21686.1215661071@sss.pgh.pa.us
Whole thread Raw
In response to Re: SELECT Query returns empty  ("Bright D.L." <dl_bright@star-quest.com>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Inaccurate row count estimation
Next
From: "Pavel Stehule"
Date:
Subject: Re: array sort for varchar arrays?