From: | Alfred Perlstein <bright(at)wintelcom(dot)net> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | yowch: dumpRules(): SELECT failed for table website. |
Date: | 2000-05-24 09:10:58 |
Message-ID: | 20000524021058.Q28097@fw.wintelcom.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
while doing a pg_dump of a table after postgresql made a mess of itself:
dumpRules(): SELECT failed for table website. Explanation from backend: 'ERROR: cache lookup of attribute 1 in relation 9892634 failed
'.
Guys, there has to be a simple command to fix a corrupted database.
I'm really killing myself over here trying to mix REINDEX, VACUUM
along with creating temp tables and reinserting the data which gives me:
dumpRules(): SELECT failed for table webmaster. Explanation from backend: 'ERROR: cache lookup of attribute 2 in relation 9892495 failed
'.
:(
Yup, we're still willing to pay for support.
The database isn't even active but seems to be corrupting itself just
by running these administrative commands.
Would anyone like access to the box? I'm currently recompiling a what
I hope is 7.0.1 to give it a shot.
thanks,
--
-Alfred Perlstein - [bright(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
"I have the heart of a child; I keep it in a jar on my desk."
From | Date | Subject | |
---|---|---|---|
Next Message | SL Baur | 2000-05-24 09:19:33 | Re: yowch: dumpRules(): SELECT failed for table website. |
Previous Message | Chris Bitmead | 2000-05-24 06:27:18 | Re: [GENERAL] Re: Postgresql OO Patch |