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
S. M. Stoller Corp
105 Technology Drive, Suite 190
Broomfield, CO 80021
www.stoller.com
303-546-4300
303-443-1408 fax
303-546-4422 direct
303-828-7576 cell