Mike Mascari <mascarm@mascari.com> writes:
> brianb-pggeneral@edsamail.com wrote:
>> How do I fix this? This is on 6.5.
> 1. Change to the location of the datafiles, which, for a
> database, called "mydatabase" will look something like:
> 2. Create an empty file of the name of the index:
> 3. Delete the file using psql:
> 4. Recreate the index as appropriate
And
5. Update to 7.0.2 at your earliest convenience, if not sooner.
No smileys here. I've noticed several people lately saying they're
still on 6.5 (or earlier :-() because they're "waiting for 7.0 to
settle out". Wake up and smell the roses folks. 7.0 certainly has
bugs, and maybe a few teething pains yet to go, but it has far fewer
bugs than any prior release --- and most of the bugs it does have
are undoubtedly present in prior releases as well. Holding off on
an update isn't buying you anything except continued exposure to the
hundreds of bugs we've swatted since 6.5.
regards, tom lane