Re: Transaction ID in Triggers - Mailing list pgsql-novice

---

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.

            regards, tom lane