Re: SELECT Query returns empty

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Bright D(dot)L(dot)" <dl_bright(at)star-quest(dot)com>
Cc: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: SELECT Query returns empty
Date: 2008-07-10 03:37:51
Message-ID: 21686.1215661071@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Bright D.L." <dl_bright(at)star-quest(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2008-07-10 05:24:53 Re: array sort for varchar arrays?
Previous Message Tom Lane 2008-07-10 03:26:14 Re: Inaccurate row count estimation