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

From: Susan Cassidy <susan(dot)cassidy(at)decisionsciencescorp(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: any way for a transaction to "see" inserts done earlier in the transaction?
Date: 2014-04-16 23:27:13
Message-ID: CAE3Q8omsvWwmtk48BDgY+3GKkoAywGnfeLwRgPhHQ5wL_7vKJA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

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