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 4193.1132607688@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:
> On Nov 21, 2005, at 12:44 PM, Tom Lane wrote:
>> Try dropping the type.

> I did try that, I guess it didn't make it to the list yet:

> mochi=# drop type ping_1132387200;
> ERROR:  cache lookup failed for relation 211174567

Hmm, apparently there are still entries in pg_depend for these objects.
Would you look to see what is in pg_depend with either objid or refobjid
equal to either 211174567 or the type's oid (possibly 211174568, but
check)?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Data directory on read-only media
Next
From: Bob Ippolito
Date:
Subject: Re: PostgreSQL 8.1.0 catalog corruption