Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] Re: have trouble understanding xmin and xmax with update operationsfrom two different sessions - Mailing list pgsql-general

From rajan
Subject [GENERAL] Re: have trouble understanding xmin and xmax with update operationsfrom two different sessions
Date
Msg-id 1499103597177-5969857.post@n3.nabble.com
Whole thread Raw
In response to Re: [GENERAL] Re: have trouble understanding xmin and xmax withupdate operations from two different sessions  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: [GENERAL] Re: have trouble understanding xmin and xmax withupdate operations from two different sessions  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Jeff Janes
Date:
Subject: Re: [GENERAL] Re: have trouble understanding xmin and xmax withupdate operations from two different sessions
Next
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] Using 'WITH SELECT' Results Do Not Match 'SELECT FROM' Results