On Apr 16, 2014, at 4:27 PM, Susan Cassidy <susan.cassidy@xxxxxxxxxxxxxxxxxxxxxxxx> wrote: > 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. Did you try it? This is already how it works, unless I misunderstand your question… postgres=# create temporary table foo (i integer primary key); CREATE TABLE postgres=# begin; BEGIN postgres=# insert into foo values(1); INSERT 0 1 postgres=# select * from foo; i --- 1 (1 row) postgres=# commit; COMMIT -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
