Sorry to not reply in one post, here is as close a reference as I could
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
> -----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,
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
pgsql-novice by date
|Next:||From: Wim||Date: 2002-06-07 13:28:47|
|Subject: HELP! Cannot access table!!!!|
|Previous:||From: Henshall, Stuart - WCP||Date: 2002-06-07 09:16:00|
|Subject: Re: META vacuum - FAIL: ERROR|