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 CAE3Q8o=6cMZGLMj9qtgVEuxJ3L9aebZHymFGLEvWEzx9p13QFg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: any way for a transaction to "see" inserts done earlier in the transaction?  (John R Pierce <pierce@hogranch.com>)
Ответы Re: any way for a transaction to "see" inserts done earlier in the transaction?  (Andy Colson <andy@squeakycode.net>)
Список pgsql-general
Дерево обсуждения
Yes, it is the same connection.  It is all the same transaction.

Susan


On Wed, Apr 16, 2014 at 5:00 PM, John R Pierce <pierce@hogranch.com> wrote:
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



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

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