Postgres Pro
Downloads
Home   >   mailing lists

Re: Modifying FK constraints - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Modifying FK constraints
Date
Msg-id 20041110173108.GA17563@winnie.fuhr.org
Whole thread Raw
In response to Modifying FK constraints  ("Oleg Lebedev" <oleglebedev@waterford.org>)
List pgsql-general
Tree view 
On Wed, Nov 10, 2004 at 10:00:02AM -0700, Oleg Lebedev wrote:

> Is it possible to modify a foreign key constraint and force it to
> cascade on update? If there is no such SQL command, then is it possible
> to update some system tables to accomplish this?

You can drop and add constraints with ALTER TABLE.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: Mike Nolan
Date:
Subject: Re: Important Info on comp.databases.postgresql.general
Next
From: "Oleg Lebedev"
Date:
Subject: Re: Modifying FK constraints