Re: FK Constraint on index not PK

Stéphane Schildknecht wrote:
>
> 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).

Try the --list and --use-list options on pg_restore. IIRC indexes are
mentioned as items in that, so you should be able to comment out the one
you don't want.

HTH
--
   Richard Huxton
   Archonet Ltd