Re: Modifying FK constraints

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Oleg Lebedev <oleglebedev(at)waterford(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Modifying FK constraints
Date: 2004-11-10 17:31:08
Message-ID: 20041110173108.GA17563@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2004-11-10 17:36:34 Re: Modifying FK constraints
Previous Message Mike Nolan 2004-11-10 17:29:52 Re: Important Info on comp.databases.postgresql.general