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?

It's version 6.5.3 . Does this limit my solutions then?

>
> > 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.
>

Rob Mosher