From: | "Greg Cocks" <gcocks(at)stoller(dot)com> |
---|---|
To: | "PostgreSQL List - Novice" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Changing 'on update' actions on existing FK constraints |
Date: | 2008-01-16 17:38:29 |
Message-ID: | 66F6CF82BF58CE4DB4285BE816B297E83BB14A@tribble.SMStoller.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hello,
I set up various FK constraints to various reference / look-up tables
with 'On Update' = 'NO ACTION'
After working with the data, I would like some in particular to 'On
Update' = 'CASCADE'
I have been looking for a method to do this directly - Googling, RTFM,
etc, etc with no luck...
(Have been deleting and redoing the constraints in pgAdmin - time
consuming as you can imagine, potentially error prone, etc - even with
the ERD to hand!)
Can this in fact be done directly on an existing FK constraint?
TIA!
----------
Regards,
GREG COCKS
GIS Analyst V
gcocks | at | stoller.com <blocked::mailto:gcocks(at)stoller(dot)com>
S. M. Stoller Corp
105 Technology Drive, Suite 190
Broomfield, CO 80021
www.stoller.com <blocked::http://www.stoller.com/>
303-546-4300
303-443-1408 fax
303-546-4422 direct
303-828-7576 cell
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Winkler | 2008-01-17 16:23:41 | Re: domains, types, constraints |
Previous Message | LWATCDR | 2008-01-16 15:22:15 | Thanks everybody. |