Changing 'on update' actions on existing FK constraints

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

Browse pgsql-novice by date

  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.