[GENERAL] Re: have trouble understanding xmin and xmax with update operationsfrom two different sessions

Поиск
Список
Период
Сортировка
От rajan
Тема [GENERAL] Re: have trouble understanding xmin and xmax with update operationsfrom two different sessions
Дата
Msg-id 1499103597177-5969857.post@n3.nabble.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Re: have trouble understanding xmin and xmax withupdate operations from two different sessions  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: [GENERAL] Re: have trouble understanding xmin and xmax withupdate operations from two different sessions
Список pgsql-general
Дерево обсуждения 
Thanks, Jeff.

Now I am going back to my old question.

Even though *Session 2* fails to update with UPDATE 0 message, its txid is
saved in xmax of updated(by *Session 1*) tuple.

As it becomes an old txid, how come new txids are able to view it?



-----
--
Thanks,
Rajan.
--
View this message in context:
http://www.postgresql-archive.org/Re-have-trouble-understanding-xmin-and-xmax-with-update-operations-from-two-different-sessions-tp5969644p5969857.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: [GENERAL] Re: have trouble understanding xmin and xmax withupdate operations from two different sessions
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] Using 'WITH SELECT' Results Do Not Match 'SELECT FROM' Results