Date: Tue, 15 May 2007 20:38:09 -0500
From: "Jim C. Nasby" <decibel@decibel.org>
To: Peter Hanson <lists@pkhanson.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Adding "on delete cascade" to all foreign key constraints
Message-ID: <20070516013809.GH11533@nasby.net>
References: <200705151219.54324.lists@pkhanson.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <200705151219.54324.lists@pkhanson.com>
User-Agent: Mutt/1.5.13 (2006-08-11)

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@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)