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

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: any way for a transaction to "see" inserts done earlier in the transaction?
Дата
Msg-id 534F19B5.9020602@hogranch.com
обсуждение исходный текст
Ответ на Re: any way for a transaction to "see" inserts done earlier in the transaction?  (Susan Cassidy <susan.cassidy@decisionsciencescorp.com>)
Ответы Re: any way for a transaction to "see" inserts done earlier in the transaction?  (Susan Cassidy <susan.cassidy@decisionsciencescorp.com>)
Список pgsql-general
On 4/16/2014 4:53 PM, Susan Cassidy wrote:
> 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.

are you using the same connection ?   it won't be visible to a different
connection until its committed.

--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



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

Предыдущее
От: Steven Schlansker
Дата:
Сообщение: 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?