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

From Tom Lane
Subject Re: Transaction ID in Triggers
Date
Msg-id 28041.1250282300@sss.pgh.pa.us
Whole thread Raw
In response to Re: Transaction ID in Triggers  (David Saracini <dsaracini@yahoo.com>)
Responses Re: Transaction ID in Triggers  (David Saracini <dsaracini@yahoo.com>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: David Saracini
Date:
Subject: Re: Transaction ID in Triggers
Next
From: David Saracini
Date:
Subject: Re: Transaction ID in Triggers