Re: FK Constraint on index not PK

Scott Marlowe a écrit :
> Being quite familiar with both of those issues from the past, I can't
> imagine either one causing a problem with an update prior to dumping so
> he can then upgrade to 8.2.
>
> Seriously.  Hungarian collation, plerl can no longer change locale and
> corrupt indexes, and a minor security update.
>
> And none of them need to be applied to do the pg_dump and then import to
> 8.2
>
> Now, if he were gonna keep the 7.4 machine up and running, then I'd
> definitely recommend he look into the points made in the release notes
> for those versions.  But all the OP seemed to be in search of was
> dropping those extra indexes before dumping / migrating to 8.2.
>
>

My goal is to migrate to 8.2.1. definitely. But as you said it, I do not
want to recreate unwanted index when migrating. I want to drop them BEFORE.

But, I can't just do a "drop index" command. It fails.

That's why I asked for an advice to drop them or not recreate them. I
would really prefer not to parse the all dump (some GB).

Thx

SAS