From: | "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk> |
---|---|
To: | 'Albert Csaba' <maka_cs(at)yahoo(dot)com> |
Cc: | "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: META vacuum - FAIL: ERROR |
Date: | 2002-06-06 09:49:24 |
Message-ID: | E2870D8CE1CCD311BAF50008C71EDE8E01F748D6@MAIL_EXCHANGE |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Henshall, Stuart - WCP | 2002-06-06 13:05:42 | Re: META vacuum - FAIL: ERROR |
Previous Message | Henshall, Stuart - WCP | 2002-06-06 09:22:30 | Re: Unable to access records in table! |