Postgres Pro
Downloads
Home   >   mailing lists

Re: Alter table to "on update cascade" - Mailing list pgsql-general

From Aram Fingal
Subject Re: Alter table to "on update cascade"
Date
Msg-id 139419D8-368E-4B39-ACD5-2958FAB3A291@multifactorial.com
Whole thread Raw
In response to Re: Alter table to "on update cascade"  (Richard Broersma <richard.broersma@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

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