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-07 10:07:00
Message-ID: E2870D8CE1CCD311BAF50008C71EDE8E01F748E1@MAIL_EXCHANGE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Sorry to not reply in one post, here is as close a reference as I could
easily find:
http://archives.postgresql.org/pgsql-sql/1999-06/msg00005.php
http://archives.postgresql.org/pgsql-hackers/1999-10/msg00084.php
http://archives.postgresql.org/pgsql-general/1999-12/msg00445.php
NB I said in my last post dump restore, you'd probably need to dump all,
initdb then restore all if just receating the index doesn't work
- Stuart

> -----Original Message-----
> From: Albert Csaba [mailto:maka_cs(at)yahoo(dot)com]
> Sent: 07 June 2002 10:02
> To: Henshall, Stuart - WCP
> Subject: RE: [NOVICE] META vacuum - FAIL: ERROR
>
>
>
> --- "Henshall, Stuart - WCP"
> <SHenshall(at)westcountrypublications(dot)co(dot)uk> wrote:
> > I've never used 6.5, but I vaguely recall an error
> > with heap a similar error
> > to the one you report being something in the
> > old/full vacuum for moving
> > chains. I believe it was said to just stop vacuum.
> > It might be worth a scan
> > of the archives (I seem to recall Tom Lane gave the
> > reason).
> > I would have thought just dropping the index and
> > recreating would be ok, but
> > have never come across this problem myself.
> > Regards,
> > - Stuart
>
> Thank you for your help. I couldn't find anything
> related to my problem in the archives. I guess I'll
> give up... hope it won't lead me to more severe errors
> :-)
>
> Thank you,
> kind regards,
> Csaba
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
>

Browse pgsql-novice by date

  From Date Subject
Next Message Wim 2002-06-07 13:28:47 HELP! Cannot access table!!!!
Previous Message Henshall, Stuart - WCP 2002-06-07 09:16:00 Re: META vacuum - FAIL: ERROR