| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Stéphane Schildknecht <stephane(dot)schildknecht(at)postgresqlfr(dot)org> |
| Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: FK Constraint on index not PK |
| Date: | 2007-01-13 13:10:45 |
| Message-ID: | 45A8DA55.1030307@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2007-01-13 13:43:57 | Re: FK Constraint on index not PK |
| Previous Message | Shane Ambler | 2007-01-13 12:43:20 | Re: XEON familiy 5000, 5100 or 5300? |