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

Поиск
Список
Период
Сортировка
От Susan Cassidy
Тема any way for a transaction to "see" inserts done earlier in the transaction?
Дата
Msg-id CAE3Q8omsvWwmtk48BDgY+3GKkoAywGnfeLwRgPhHQ5wL_7vKJA@mail.gmail.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Alan Nilsson
Дата:
Сообщение: shared memory allocation - C function
Следующее
От: Steven Schlansker
Дата:
Сообщение: Re: any way for a transaction to "see" inserts done earlier in the transaction?