Postgres Pro
Downloads
Home   >   mailing lists

Re: any way for a transaction to "see" inserts done earlier in the transaction? - Mailing list pgsql-general

From Susan Cassidy
Subject Re: any way for a transaction to "see" inserts done earlier in the transaction?
Date
Msg-id CAE3Q8o=6cMZGLMj9qtgVEuxJ3L9aebZHymFGLEvWEzx9p13QFg@mail.gmail.com
Whole thread Raw
In response to Re: any way for a transaction to "see" inserts done earlier in the transaction?  (John R Pierce <pierce@hogranch.com>)
Responses Re: any way for a transaction to "see" inserts done earlier in the transaction?  (Andy Colson <andy@squeakycode.net>)
List pgsql-general
Tree view
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 <pierce@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

pgsql-general by date:

Previous
From: Susan Cassidy
Date:
Subject: Re: any way for a transaction to "see" inserts done earlier in the transaction?
Next
From: Susan Cassidy
Date:
Subject: Re: any way for a transaction to "see" inserts done earlier in the transaction?