Can't access a table. It seems to have been corrupted hsomehow - Mailing list pgsql-sql

From Robert Chalmers
Subject Can't access a table. It seems to have been corrupted hsomehow
Date
Msg-id 004101bf9bb7$354380c0$1a6001cb@chalmers.com.au
Whole thread Raw
Responses Re: Can't access a table. It seems to have been corrupted hsomehow  (Tulassay Zsolt <zsolt@tek.bke.hu>)
List pgsql-sql
I have a database with a group of tables in it.

One of the tables seems to have been modified somehow, and no - although I
can see it with \d I can't actually do anyting to it. Any action, like
rename, insert, drop gives a message "table doesn't exist". If I try to jsut
creat it again, it says "can't do that, it already exists!" (words to that
effect)

So - does it exist or not? How do I actually get rid of that particular
table all together without destroying the whole database?

bob






pgsql-sql by date:

Previous
From: S Kalyanasundaram
Date:
Subject: Stored Procedures..
Next
From: Philippe Lefèvre
Date:
Subject: Trying to use a foreign key with Postgresql