Boy... I had the screwed up! :) Thanks for explaining.
Regards,
David
From: Tom Lane <tgl@sss.pgh.pa.us> To: David Saracini <dsaracini@yahoo.com> Cc: pgsql novice forum <pgsql-novice@postgresql.org> Sent: Friday, August 14, 2009 1:38:20 PM Subject: Re: [NOVICE] Transaction ID in Triggers
David Saracini <dsaracini@yahoo.com> writes: > So, if I understand it... then, txid_current returns the xmax in the > high-order and the xmin in the low-order. Correct?
No. txid_current returns a monotonically increasing version of the transaction counter --- its high order bits are an "epoch" counter that increases whenever the 32-bit xid wraps around.