Re: META vacuum - FAIL: ERROR

Try:
http://www.postgresql.org/idocs/index.php?sql-reindex.html
This has a better explanation than I could manage :)
hth,
- Stuart

> -----Original Message-----
> From: Albert Csaba [mailto:maka_cs(at)yahoo(dot)com]
> Sent: 06 June 2002 10:38
> To: Henshall, Stuart - WCP
> Subject: Re: [NOVICE] META vacuum - FAIL: ERROR
>
>
>
> --- "Henshall, Stuart - WCP"
> <SHenshall(at)westcountrypublications(dot)co(dot)uk> wrote:
> >
> >
> > > -----Original Message-----
> > > From: Albert Csaba [mailto:maka_cs(at)yahoo(dot)com]
> > >
> > > Hi!
> > >
> > > I have a RaQ3 Cobalt server, which uses
> > PostgreSQL.
> > > Lately I'm getting this error:
> > >
> > > NOTICE: Index pg_attribute_attrelid_index: NUMBER
> > OF
> > > INDEX' TUPLES (574) IS NOT THE SAME AS HEAP' (561)
> > > NOTICE: Index pg_attribute_relid_attnum_index:
> > NUMBER
> > > OF INDEX' TUPLES (574) IS NOT THE SAME AS HEAP'
> > (561)
> > > NOTICE: Index pg_attribute_relid_attnam_index:
> > NUMBER
> > > OF INDEX' TUPLES (574) IS NOT THE SAME AS HEAP'
> > (561)
> > > META vacuum - FAIL: ERROR: cannot find attribute
> > 1 of
> > > relation quota
> > >
> > > What can I do? Can I change manually somehow the
> > > database?
> > >
> > > Any help is welcome,
> > > Thank you in advance
> > >
> > > Csaba Albert
> >
> > Try reindex from a stand alone postgres (just
> > postgres rather than
> > postmaster).
> > This should reindex the system tables.
> > hth,
> > - Stuart
> >
>
> Thanks for your answer. But to save me some time and
> if not's so much trouble to you, how do I make
> reindex?
>
> Csaba Albert
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
>