Re: have trouble understanding xmin and xmax with update operations from two different sessions

From: rajan <vgmonnet(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: have trouble understanding xmin and xmax with update operations from two different sessions
Date: 2017-07-03 17:39:57
Message-ID: 1499103597177-5969857.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2017-07-03 23:21:46 Re: Using 'WITH SELECT' Results Do Not Match 'SELECT FROM <table>' Results
Previous Message Jeff Janes 2017-07-03 15:35:22 Re: Re: have trouble understanding xmin and xmax with update operations from two different sessions