Skip site navigation (1) Skip section navigation (2)

Re: META vacuum - FAIL: ERROR

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 (view raw or flat)
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
> 

pgsql-novice by date

Next:From: Henshall, Stuart - WCPDate: 2002-06-06 13:05:42
Subject: Re: META vacuum - FAIL: ERROR
Previous:From: Henshall, Stuart - WCPDate: 2002-06-06 09:22:30
Subject: Re: Unable to access records in table!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group