Re: changing referential integrety action on existing table

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Matthew Nuzum <cobalt(at)bearfruit(dot)org>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: changing referential integrety action on existing table
Date: 2003-02-06 20:19:13
Message-ID: 20030206121737.F41355-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, 6 Feb 2003, Matthew Nuzum wrote:

> I have a table that uses the NO ACTION action for it's referential
> integrity. I'd like to change it to CASCADE for the ON DELETE event.
> I'm using Postgres 7.2.

I think the best way is to drop all three triggers for the constraint and
use alter table add constraint to add the constraint again withe the
options you want.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-02-06 20:29:58 Re: numeric when compared to literal
Previous Message Chad Thompson 2003-02-06 19:28:30 Re: 7.2 functions that return multiple result sets?