"Alvaro Herrera" <alvherre@xxxxxxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
