[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 1498967757297-5969661.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. That helps understanding it 50%.

*Session 2* fails to UPDATE the record which is in *(0,2)* and this tuple is
marked for deletion. It means that *(0,2) never exists* when Session 2 is
trying to perform the update.

In that case, how *Session 3's new row (0,4)* contains the xmax as *Session
2's txid*.



-----
--
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-tp5969644p5969661.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
Следующее
От: rajan
Дата:
Сообщение: [GENERAL] Need help on compiling postgres source code from cloned repo