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 Tom Lane
Subject Re: any way for a transaction to "see" inserts done earlier in the transaction?
Date
Msg-id 18378.1397691104@sss.pgh.pa.us
Whole thread Raw
In response to 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
Tree view 
Susan Cassidy <susan.cassidy@decisionsciencescorp.com> writes:
> Is there any way to let a transaction "see" the inserts that were done
> earlier in the transaction?

It works that way automatically, as long as you're talking about separate
statements within one transaction.

            regards, tom lane

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?