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

* Hiroshi Inoue <Inoue@tpf.co.jp> [000524 02:40] wrote:
> > -----Original Message-----
> > From: pgsql-hackers-owner@hub.org [mailto:pgsql-hackers-owner@hub.org]On
> > Behalf Of Alfred Perlstein
> > 
> > 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:
> >
> 
> How did you issue REINDEX command ?

postmaster -p 1080 -o "-O -P"
was run
then:

psql -p 1080 webcounter
REINDEX DATABASE webcounter force;

-- 
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."