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

On 04/16/2014 07:06 PM, Susan Cassidy wrote:
> 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 <mailto: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.
Itis 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
>


Any chance you accidentally fired of a rollback?

-Andy