Re: PostgreSQL 8.1.0 catalog corruption

From: Bob Ippolito <bob(at)redivi(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: PostgreSQL 8.1.0 catalog corruption
Date: 2005-11-21 20:52:44
Message-ID: 1C556166-AFD8-429E-83D7-5A5540ED2898@redivi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On Nov 21, 2005, at 12:44 PM, Tom Lane wrote:

> Bob Ippolito <bob(at)redivi(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2005-11-21 20:52:57 Re: PostgreSQL 8.1.0 catalog corruption
Previous Message Simon Riggs 2005-11-21 20:51:32 Are NULLs in Arrays compressed?