Re: Alter table to "on update cascade"

From: Aram Fingal <fingal(at)multifactorial(dot)com>
To: Postgres-General General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Alter table to "on update cascade"
Date: 2010-11-17 19:23:43
Message-ID: 139419D8-368E-4B39-ACD5-2958FAB3A291@multifactorial.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Nov 17, 2010, at 12:42 PM, Richard Broersma wrote:

> ALTER TABLE foo
> DROP CONSTRAINT your_constraint,
> ADD CONSTRAINT your_constraint FOREIGN KEY ...
> ON UPDATE CASCADE ON DELETE RESTRICT;

Thanks. That worked.
-Aram

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Glen Parker 2010-11-17 19:58:58 Re: Survey on backing up unlogged tables: help us with PostgreSQL development!
Previous Message Allan Kamau 2010-11-17 19:11:33 Re: Trying to obtain the intersect of two tsvector values