Re: "xmin" system column - Mailing list pgsql-general

From Michael Fuhr
Subject Re: "xmin" system column
Date
Msg-id 20060126223025.GA98934@winnie.fuhr.org
Whole thread Raw
In response to Re: "xmin" system column  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
On Thu, Jan 26, 2006 at 03:22:50PM -0700, Michael Fuhr wrote:
> On Thu, Jan 26, 2006 at 05:05:19PM -0500, Eric B. Ridge wrote:
> > Is there some kind of "TopXID" magic variable/function that I haven't
> > found in the documentation?
>
> Not in the standard installation, but I think a C function that
> returns GetTopTransactionId() should work.  It's trivial to write
> and examples have been posted before; search the archives.

Tom made a good point against using this value: it's not guaranteed
to be unique, for example after a dump and reload.  I suppose that's
a strong reason why the developers haven't provided such easy access
to it.

--
Michael Fuhr

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: "xmin" system column
Next
From: Scott Marlowe
Date:
Subject: Re: Arrays