yowch: dumpRules(): SELECT failed for table website.

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

Responses

Browse pgsql-hackers by date

  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