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@yahoo.com]
> Sent: 07 June 2002 10:02
> To: Henshall, Stuart - WCP
> Subject: RE: [NOVICE] META vacuum - FAIL: ERROR
>
>
>
> --- "Henshall, Stuart - WCP"
> <SHenshall@westcountrypublications.co.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
>
