Request a Demo
Home   >   mailing lists

Adding "on delete cascade" to all foreign key constraints - Mailing list pgsql-sql

From Peter Hanson
Subject Adding "on delete cascade" to all foreign key constraints
Date
Msg-id 200705151219.54324.lists@pkhanson.com
Whole thread Raw
Responses Re: Adding "on delete cascade" to all foreign key constraints
List pgsql-sql
Tree view 
Hello,

I was wondering if there's a fast way I can add "on delete cascade" to all 
foreign key constraints in my database?  Maybe a quick update I can make 
against the catalog possibly? Or is there a way I can query for all foreign 
key constrains in the database and then I could write up a quick script to do 
the updates for me.

Any help is appreciated, TIA,

Pete Hanson

pgsql-sql by date:

Previous
From: Gary Stainburn
Date:
Subject: Re: workday function
Next
From: Rodrigo De León
Date:
Subject: Re: SQL Query Validate Records Multiple Tables - Help Needed