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 [EMAIL PROTECTED]:/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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
