Re: FW: Duplicate oids!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Steve King <steve(dot)king(at)ecmsys(dot)co(dot)uk>
Cc: "'Hannu Krosing'" <hannu(at)tm(dot)ee>, "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: FW: Duplicate oids!
Date: 2002-12-13 14:43:19
Message-ID: 9207.1039790599@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Steve King <steve(dot)king(at)ecmsys(dot)co(dot)uk> writes:
> The ctids are different however vaccum is run on this table and the record
> is updated.

It would be useful to look at xmin,xmax,cmin,cmax of these tuples too.

Actually, if you don't mind grabbing a copy of pg_filedump --- see
http://sources.redhat.com/rhdb/tools.html --- then a dump of page 7
of that relation would be good to look at. I am wondering about the
states of the infomask bits for these tuples...

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Treat 2002-12-13 14:44:26 Re: Creating a zero-column table
Previous Message darren 2002-12-13 14:13:26 Re: Big 7.4 items