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

2017-07-01 Thread stevenchang1213
this chapter introduces mvcc http://www.interdb.jp/pg/pgsql05.html 原始訊息 自: rajan <vgmon...@gmail.com> 日期: 2017/7/1 14:32 (GMT+08:00) 至: pgsql-general@postgresql.org 主旨: [GENERAL] have trouble understanding xmin and xmax with update operations from two different se

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

2017-07-01 Thread Adrian Klaver
On 06/30/2017 11:32 PM, rajan wrote: have trouble understanding xmin and xmax with update operations from two different sessions So, as found below, Session2 is trying to update a row which is already updated with a different value and it's update fails with *UPDATE 0* But from Session3, I see

[GENERAL] have trouble understanding xmin and xmax with update operations from two different sessions

2017-07-01 Thread rajan
have trouble understanding xmin and xmax with update operations from two different sessions So, as found below, Session2 is trying to update a row which is already updated with a different value and it's update fails with *UPDATE 0* But from Session3, I see that xmax value is visible as