Re: a few questions (and doubts) about xid - Mailing list pgsql-general

"Alvaro Herrera" <alvherre@commandprompt.com> writes:

> Gregory Stark wrote:
>
>> > Just for confirmation: the relfrozenxid of a fresh table is the xid of the
>> > transaction that created it, isn't it?
>>
>> Yes, easily enough checked:
>>
>> postgres=# create table xyz (i integer);
>> CREATE TABLE
>> postgres=# select xmin,relfrozenxid from pg_class where relname = 'xyz';
>
> No it's not.  It's the XID of the earliest transaction that was open at
> the time you created the table (known as RecentXid).

Mea culpa. That's a pretty obvious error too; I should have thought more
before sending that message.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com