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

From Susan Cassidy
Subject any way for a transaction to "see" inserts done earlier in the transaction?
Date
Msg-id CAE3Q8omsvWwmtk48BDgY+3GKkoAywGnfeLwRgPhHQ5wL_7vKJA@mail.gmail.com
Whole thread Raw
Responses Re: any way for a transaction to "see" inserts done earlier in the transaction?  (Steven Schlansker <steven@likeness.com>)
Re: any way for a transaction to "see" inserts done earlier in the transaction?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Is there any way to let a transaction "see" the inserts that were done earlier in the transaction?  I want to insert a row, then later use it within the same transaction.

If not, I will have to commit after each insert, and I don't want to do that until add the rows are added, if I can possibly avoid it.

Thanks,
Susan

pgsql-general by date:

Previous
From: Alan Nilsson
Date:
Subject: shared memory allocation - C function
Next
From: Steven Schlansker
Date:
Subject: Re: any way for a transaction to "see" inserts done earlier in the transaction?