Re: PostgreSQL 8.1.0 catalog corruption

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