Yes, it is the same connection. It is all the same transaction. Susan
On Wed, Apr 16, 2014 at 5:00 PM, John R Pierce <pie...@hogranch.com> wrote: > On 4/16/2014 4:53 PM, Susan Cassidy wrote: > >> Well, it isn't working for me right now. It can't "see" a row that was >> inserted earlier in the transaction. It is a new primary key, and when I >> SELECT it, it isn't found. >> > > are you using the same connection ? it won't be visible to a different > connection until its committed. > > -- > john r pierce 37N 122W > somewhere on the middle of the left coast > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
