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

From Bob Ippolito
Subject Re: PostgreSQL 8.1.0 catalog corruption
Date
Msg-id 1C556166-AFD8-429E-83D7-5A5540ED2898@redivi.com
Whole thread Raw
In response to Re: PostgreSQL 8.1.0 catalog corruption  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: PostgreSQL 8.1.0 catalog corruption  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Nov 21, 2005, at 12:44 PM, Tom Lane wrote:

> Bob Ippolito <bob@redivi.com> writes:
>> mochi=# drop table ping_1132387200;
>> ERROR:  table "ping_1132387200" does not exist
>> mochi=# create table ping_1132387200();
>> ERROR:  type "ping_1132387200" already exists
>
>> I'm not sure what to do about this..
>
> Try dropping the type.
>
> We've seen at least one prior report of a table's rowtype not being
> dropped with the table, but nothing solid enough to debug.  If you can
> find a way to reproduce this, I'm all ears.

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

-bob






pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Are NULLs in Arrays compressed?
Next
From: Alvaro Herrera
Date:
Subject: Re: PostgreSQL 8.1.0 catalog corruption