| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Hannes Dorbath <light(at)theendofthetunnel(dot)de> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Cascade constraint renames? |
| Date: | 2006-04-26 08:58:14 |
| Message-ID: | 444F3626.9080407@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hannes Dorbath wrote:
> How to rename PK constraints that are referenced in various tables,
> without dropping down the entire dependency tree and recreate everything
> (at least all FKs) afterwards?
>
> Dump-edit-reload is not an option, as the database size is way to huge.. :/
Not sure you can. There's no ALTER TABLE ... RENAME CONSTRAINT command.
You might be able to do something by updating the system catalogues
directly but I'd not feel comfortable doing so without a lot of testing.
Can I ask *why* you are renaming constraints? What difference does it
make what they are called?
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alban Hertroys | 2006-04-26 09:48:14 | Re: SQL Rule |
| Previous Message | Hannes Dorbath | 2006-04-26 08:40:46 | Cascade constraint renames? |