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 3953.1132605893@sss.pgh.pa.us
Whole thread Raw
In response to PostgreSQL 8.1.0 catalog corruption  (Bob Ippolito <bob@redivi.com>)
Responses Re: PostgreSQL 8.1.0 catalog corruption
List pgsql-hackers
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.
        regards, tom lane


pgsql-hackers by date:

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