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