Re: FW: Duplicate oids! - Mailing list pgsql-hackers

From Tom Lane
Subject Re: FW: Duplicate oids!
Date
Msg-id 9207.1039790599@sss.pgh.pa.us
Whole thread Raw
In response to Re: FW: Duplicate oids!  (Steve King <steve.king@ecmsys.co.uk>)
Responses Re: FW: Duplicate oids!
List pgsql-hackers
Steve King <steve.king@ecmsys.co.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


pgsql-hackers by date:

Previous
From:
Date:
Subject: Re: Big 7.4 items
Next
From: Robert Treat
Date:
Subject: Re: Creating a zero-column table