On Nov 21, 2005, at 11:31 AM, 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
I'm not sure what to do about this..
Oh, and trying to drop the type doesn't work either:
mochi=# drop type ping_1132387200;
ERROR: cache lookup failed for relation 211174567
-bob
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
