Adding "on delete cascade" to all foreign key constraints

Поиск
Список
Период
Сортировка
От Peter Hanson
Тема Adding "on delete cascade" to all foreign key constraints
Дата
Msg-id 200705151219.54324.lists@pkhanson.com
обсуждение исходный текст
Ответы Re: Adding "on delete cascade" to all foreign key constraints  ("Jim C. Nasby" <decibel@decibel.org>)
Список pgsql-sql
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 по дате отправления:

Предыдущее
От: Gary Stainburn
Дата:
Сообщение: Re: workday function
Следующее
От: Rodrigo De León
Дата:
Сообщение: Re: SQL Query Validate Records Multiple Tables - Help Needed