Re: PostgreSQL 8.1.0 catalog corruption

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

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.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2005-11-21 20:51:32 Are NULLs in Arrays compressed?
Previous Message Bob Ippolito 2005-11-21 20:38:00 Re: PostgreSQL 8.1.0 catalog corruption