Re: Corrupted table

Robert Mosher <mosher@andrews.edu> writes:
> In a Perl script I ended up trying to UPDATE a row in my database with a
> value that was out of the range. Now whenever I try to do something with
> the table I get the error:

>     ERROR:  mdopen: couldn't open tablename: No such file or directory

It seems unlikely that the one led to the other.  The known ways to
cause that type of failure involve other things, like trying to roll
back a DROP TABLE.

How old is your Postgres?

> I can't even drop the table, despite the fact that it shows up when I
> enter '\dt' in psql. I could probably run destroydb on the
> database that contains the table,

If it's called "destroydb" and not "dropdb", then the answer to my
question is "too old".  Consider an update, soon.

            regards, tom lane