Re: [HACKERS] FW: Duplicate oids!

2002-12-18 Thread Patrick Macdonald
Patrick Macdonald wrote: > > Tom Lane wrote: > > > > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > > On Fri, Dec 13, 2002 at 09:43:19AM -0500, Tom Lane wrote: > > >> Actually, if you don't mind grabbing a copy of pg_filedump --- see > > >> http://sources.redhat.com/rhdb/tools.html > > > > > Has t

Re: [HACKERS] FW: Duplicate oids!

2002-12-16 Thread Tom Lane
Steve King <[EMAIL PROTECTED]> writes: > Files output from pg_filedump are below, > I have two tables with duplicate oids and these are the pg_filedumps for > them. Hmm. You seem to have a rather unusual usage pattern for these tables --- it looks like there are *lots* of failed (rolled back) upd

Re: [HACKERS] FW: Duplicate oids!

2002-12-16 Thread Patrick Macdonald
Tom Lane wrote: > > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > On Fri, Dec 13, 2002 at 09:43:19AM -0500, Tom Lane wrote: > >> Actually, if you don't mind grabbing a copy of pg_filedump --- see > >> http://sources.redhat.com/rhdb/tools.html > > > Has this been updated for 7.3? Last time I loo

Re: [HACKERS] FW: Duplicate oids!

2002-12-16 Thread Tom Lane
Steve King <[EMAIL PROTECTED]> 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 where is whatever p

Re: [HACKERS] FW: Duplicate oids!

2002-12-16 Thread Steve King
14:43 To: Steve King Cc: 'Hannu Krosing'; '[EMAIL PROTECTED]' Subject: Re: [HACKERS] FW: Duplicate oids! Steve King <[EMAIL PROTECTED]> writes: > The ctids are different however vaccum is run on this table and the record > is updated. It would be useful to look a

Re: [HACKERS] FW: Duplicate oids!

2002-12-13 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > On Fri, Dec 13, 2002 at 09:43:19AM -0500, Tom Lane wrote: >> Actually, if you don't mind grabbing a copy of pg_filedump --- see >> http://sources.redhat.com/rhdb/tools.html > Has this been updated for 7.3? Last time I looked it only did 7.2, and > the

Re: [HACKERS] FW: Duplicate oids!

2002-12-13 Thread Alvaro Herrera
On Fri, Dec 13, 2002 at 09:43:19AM -0500, Tom Lane wrote: > Actually, if you don't mind grabbing a copy of pg_filedump --- see > http://sources.redhat.com/rhdb/tools.html Has this been updated for 7.3? Last time I looked it only did 7.2, and the site shows an old date. If it hasn't, are there p

Re: [HACKERS] FW: Duplicate oids!

2002-12-13 Thread Tom Lane
Steve King <[EMAIL PROTECTED]> 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/rhd

Re: [HACKERS] FW: Duplicate oids!

2002-12-13 Thread Steve King
greatly appreciated. -Original Message- From: Hannu Krosing [mailto:[EMAIL PROTECTED]] Sent: 13 December 2002 11:54 To: Steve King Cc: '[EMAIL PROTECTED]' Subject: Re: [HACKERS] FW: Duplicate oids! On Fri, 2002-12-13 at 09:27, Steve King wrote: > > -Original Messa

Re: [HACKERS] FW: Duplicate oids!

2002-12-13 Thread Hannu Krosing
On Fri, 2002-12-13 at 09:27, Steve King wrote: > > -Original Message- > > From: Steve King > > Sent: 12 December 2002 11:45 > > To: [EMAIL PROTECTED] > > Subject:Duplicate oids! > > > > Forgive me if this is a previous question but I cannot find any > > information on it