Corrupted table

From: Robert Mosher <mosher(at)andrews(dot)edu>
To: Mailing List Postgresql <pgsql-novice(at)postgresql(dot)org>
Subject: Corrupted table
Date: 2001-10-08 20:44:40
Message-ID: Pine.SOL.3.91.1011008163319.10440A-100000@orion.cc.andrews.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

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, but I would prefer not too (although if
it comes to it, it wouldn't be too devastating). Is there anyway to fix
this problem.

Note: The type of the field that was out of range is int4. When I
recreate the table I'm planning to make it of type int8, but would like
to know if there is a type for unsigned integers?

Thanks,
Rob Mosher

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2001-10-08 21:43:11 Re: Corrupted table
Previous Message Josh Berkus 2001-10-08 15:47:55 Re: Starting Postmaster at boot