Re: failed to re-find parent key - Mailing list pgsql-hackers

From Dave Cramer
Subject Re: failed to re-find parent key
Date
Msg-id 1074084512.1145.102.camel@localhost.localdomain
Whole thread Raw
In response to Re: failed to re-find parent key  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: failed to re-find parent key
List pgsql-hackers
Ok, that seems to have fixed it, so my next question is how did it get
corrupt?

Dave
On Tue, 2004-01-13 at 23:07, Tom Lane wrote:
> Dave Cramer <pg@fastcrypt.com> writes:
> > Actually the hack checks for oids, and doesn't make the index, if there
> > isn't an oid in the table, so I tried it with a table without oids, and
> > it still occurs.
> 
> My thought was that at this point the indexes on pg_attribute are very
> possibly corrupt, and so just removing whatever initially caused that
> corruption won't necessarily cause the error messages to stop.  You
> should reindex pg_attribute to get back into a good state.
> 
>             regards, tom lane
> 
-- 
Dave Cramer
519 939 0336
ICQ # 1467551



pgsql-hackers by date:

Previous
From: "Mark Cave-Ayland"
Date:
Subject: Re: Suggestions for analyze patch required...
Next
From: "Merlin Moncure"
Date:
Subject: Re: Encoding problems in PostgreSQL with XML data