| From: | Steve King <steve(dot)king(at)ecmsys(dot)co(dot)uk> | 
|---|---|
| To: | 'Tom Lane' <tgl(at)sss(dot)pgh(dot)pa(dot)us> | 
| Cc: | "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org> | 
| Subject: | Re: FW: Duplicate oids! | 
| Date: | 2002-12-16 10:56:39 | 
| Message-ID: | 5B5F2A89A44ED5118A790090274DD8462AB64F@SNOOPY | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-hackers | 
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(at)sss(dot)pgh(dot)pa(dot)us]
Sent: 13 December 2002 14:43
To: Steve King
Cc: 'Hannu Krosing'; 'pgsql-hackers(at)postgresql(dot)org'
Subject: Re: [HACKERS] FW: Duplicate oids!
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Copeland | 2002-12-16 13:56:25 | Re: Big 7.4 items | 
| Previous Message | Manfred Koizar | 2002-12-16 08:58:55 | Re: PageGetMaxOffsetNumber |