I've now got a copy of pg_filedump and compiled it, can you tell me the
command line parameters to pass it (and the file that I must process) so I
can give you exactly what you require.

Thanks
Steve

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: 13 December 2002 14:43
To: Steve King
Cc: 'Hannu Krosing'; 'pgsql-hackers@postgresql.org'
Subject: Re: [HACKERS] FW: Duplicate oids!


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

Mon, 16 Dec 2002 10:56:39 -0000
Steve King <steve.king@ecmsys.co.uk>
Re: FW: Duplicate oids!
Steve King <steve.king@ecmsys.co.uk> writes:
> I've now got a copy of pg_filedump and compiled it, can you tell me the
> command line parameters to pass it (and the file that I must process) so I
> can give you exactly what you require.

I'd recommend

	pg_filedump -f -i -R <blocknum> <filename>

where <blocknum> is whatever page you need to look at (the high part of
the TIDs of the bad tuples), and <filename> is going to be of the form

	$PGDATA/base/<dbnum>/<filenum>

You get the DB number from

	select oid from pg_database where datname = 'yourdbname';

and the file number from

	select relfilenode from pg_class where relname = 'yourtablename';

			regards, tom lane

Mon, 16 Dec 2002 09:59:21 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: FW: Duplicate oids! 