Re: any way for a transaction to "see" inserts done earlier in the transaction?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Susan Cassidy <susan(dot)cassidy(at)decisionsciencescorp(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: any way for a transaction to "see" inserts done earlier in the transaction?
Date: 2014-04-16 23:31:44
Message-ID: 18378.1397691104@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Susan Cassidy <susan(dot)cassidy(at)decisionsciencescorp(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Susan Cassidy 2014-04-16 23:53:30 Re: any way for a transaction to "see" inserts done earlier in the transaction?
Previous Message Steven Schlansker 2014-04-16 23:31:03 Re: any way for a transaction to "see" inserts done earlier in the transaction?