Re: Negative result with (now()-previously_inserted_timestamp)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Negative result with (now()-previously_inserted_timestamp)
Дата
Msg-id 25752.1278476281@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Negative result with (now()-previously_inserted_timestamp)  (Gurjeet Singh <singh.gurjeet@gmail.com>)
Ответы Re: Negative result with (now()-previously_inserted_timestamp)  (Gurjeet Singh <singh.gurjeet@gmail.com>)
Re: Negative result with (now()-previously_inserted_timestamp)  (Gurjeet Singh <singh.gurjeet@gmail.com>)
Список pgsql-bugs
Дерево обсуждения 
Gurjeet Singh <singh.gurjeet@gmail.com> writes:
> I ran the following query, and got an unexpected negative value. Does this
> imply that SELECT-transaction was able to see a row created by
> INSERT-transaction which started after the SELECT-transaction?

Was the SELECT inside a BEGIN block?

            regards, tom lane

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

Предыдущее
От: Gurjeet Singh
Дата:
Сообщение: Negative result with (now()-previously_inserted_timestamp)
Следующее
От: Gurjeet Singh
Дата:
Сообщение: Re: Negative result with (now()-previously_inserted_timestamp)