On Fri, July 10, 2009 18:13, Alvaro Herrera wrote:
>
> Is it using a different PG connection than the one doing the
> insert? In that case, it won't see the new row until the
> inserting transaction commits.
That is almost certainly the exact problem. I will check and
determine if this is so but I it seems to me unavoidable that
launching a new shell for the script under test will cause another,
different, connection to be used. If this proves the case then I
will report back. If not then no doubt you will hear from me as
well.
Thank you for illuminating this for me.
>
> BTW it seems necessary to clarify that LOCATION lines correspond
> to the LOG/NOTICE/WARNING/ERROR line immediately _above_ it, not
> the one below.
>
So noted, with thanks.
Regards,
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrne mailto:ByrneJB@Harte-Lyne.ca
Harte & Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3