PostgreSQL 8.1.0 catalog corruption - Mailing list pgsql-hackers

From Bob Ippolito
Subject PostgreSQL 8.1.0 catalog corruption
Date
Msg-id 302143A2-FA7C-4A01-B2B6-50AB1E7CB885@redivi.com
Whole thread Raw
Responses Re: PostgreSQL 8.1.0 catalog corruption  (Bob Ippolito <bob@redivi.com>)
Re: PostgreSQL 8.1.0 catalog corruption  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: PostgreSQL 8.1.0 catalog corruption  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
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
\gor 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..

-bob



pgsql-hackers by date:

Previous
From: Marcus Engene
Date:
Subject: Re: bind variables, soft vs hard parse
Next
From: Bob Ippolito
Date:
Subject: Re: PostgreSQL 8.1.0 catalog corruption