Re: PostgreSQL 8.1.0 catalog corruption - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PostgreSQL 8.1.0 catalog corruption
Date
Msg-id 4469.1132609403@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgreSQL 8.1.0 catalog corruption  (Bob Ippolito <bob@redivi.com>)
Responses Re: PostgreSQL 8.1.0 catalog corruption  (Bob Ippolito <bob@redivi.com>)
List pgsql-hackers
Bob Ippolito <bob@redivi.com> writes:
> I don't know how to get the oid of a type.. but there are certainly  
> entries in pg_depend with the other criteria:

Hmph, looks like you still have a pretty full set of dependencies for
the table.  What about attributes --- tryselect attname from pg_attribute where attrelid = 211174567;

It might be interesting to try reindexing pg_class, too ... maybe the
pg_class row is still there but isn't being found because of a corrupt
index?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Data directory on read-only media
Next
From: Martijn van Oosterhout
Date:
Subject: Re: why is gist index taking so much space on the disc