Patrick Coulombe <pcoulombe(at)mediacces(dot)com> writes:
> what about if i drop it, and then vacuum or look into this table for null
> value and other bad data. and after recreate it ?
Sorry, I guess I wasn't clear: that's what I meant you to do. I'd
actually not bother with recreating the index at all, at least not
till you've gotten your data moved over to 7.1.
> it's safe to vacuum my bd after dropping an index ?
Sure. The data in the table is all you should care about at this point.
However, I think you should resign yourself to the likelihood that
you've lost data: you've got a pretty badly hosed database there,
it would seem. How recent is your last pg_dump backup?
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: JWDougherty||Date: 2001-10-07 08:25:41|
|Subject: Starting Postmaster at boot|
|Previous:||From: Patrick Coulombe||Date: 2001-10-06 21:32:57|
|Subject: Re: from 6.5 > 7.1, cannot pg_dumpall.|