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

Поиск
Список
Период
Сортировка
От Susan Cassidy
Тема Re: any way for a transaction to "see" inserts done earlier in the transaction?
Дата
Msg-id CAE3Q8okbOH+1Nocg4D=E+Cnjk73e5AO3TEuAiGpxXSVfrg8eoQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: any way for a transaction to "see" inserts done earlier in the transaction?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: any way for a transaction to "see" inserts done earlier in the transaction?
Re: any way for a transaction to "see" inserts done earlier in the transaction?
Список pgsql-general
Дерево обсуждения
Well, it isn't working for me right now.  It can't "see" a row that was inserted earlier in the transaction.  It is a new primary key, and when I SELECT it, it isn't found. 

Susan


On Wed, Apr 16, 2014 at 4:31 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Susan Cassidy <susan.cassidy@decisionsciencescorp.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

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: any way for a transaction to "see" inserts done earlier in the transaction?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: client encoding that psql command sets