Re: PostgreSQL 8.1.0 catalog corruption

Bob Ippolito wrote:
> I've been running 8.1.0 on a test box since the FreeBSD port has been  
> available, and it appears that the catalog has become corrupted.   
> There's plenty of free space on all volumes, so it hasn't run out of  
> space or anything.
> 
> $ uname -a
> FreeBSD shi.mochibot.com 6.0-RELEASE FreeBSD 6.0-RELEASE #2: Mon Nov   
> 7 14:34:52 PST 2005     root@shi.mochibot.com:/usr/obj/usr/src/sys/ 
> CUSTOM  i386
> 
> $ psql mochi
> Welcome to psql 8.1.0, the PostgreSQL interactive terminal.
> 
> Type:  \copyright for distribution terms
>        \h for help with SQL commands
>        \? for help with psql commands
>        \g or terminate with semicolon to execute query
>        \q to quit
> 
> mochi=# drop table ping_1132387200;
> ERROR:  table "ping_1132387200" does not exist
> mochi=# create table ping_1132387200();
> ERROR:  type "ping_1132387200" already exists

Well, try

DROP TYPE ping_1132387200;

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support