Re: a few questions (and doubts) about xid

[Gregory Stark <stark(at)enterprisedb(dot)com>]

"Alvaro Herrera" <alvherre(at)commandprompt(dot)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