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

From John R Pierce
Subject Re: any way for a transaction to "see" inserts done earlier in the transaction?
Date
Msg-id 534F19B5.9020602@hogranch.com
Whole thread Raw
In response to Re: any way for a transaction to "see" inserts done earlier in the transaction?  (Susan Cassidy <susan.cassidy@decisionsciencescorp.com>)
Responses Re: any way for a transaction to "see" inserts done earlier in the transaction?  (Susan Cassidy <susan.cassidy@decisionsciencescorp.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Steven Schlansker
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?