Re: Adding "on delete cascade" to all foreign key constraints

On Tue, May 15, 2007 at 12:19:54PM -0500, Peter Hanson wrote:
> 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.

You shouldn't go mucking about with the system tables unless absolutely
necessary. Instead, write a SELECT that outputs the appropriate syntax.
You could do that by querying the catalogs directly, but I think you'll
find the pg_user_foreign_keys view defined by
http://pgfoundry.org/projects/newsysviews to be most helpful.
--
Jim Nasby decibel(at)decibel(dot)org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)