Re: Alter table to "on update cascade"

Richard Broersma <richard.broersma@xxxxxxxxx> · Wed, 17 Nov 2010 09:42:55 -0800

On Wed, Nov 17, 2010 at 8:43 AM, David Fetter <david@xxxxxxxxxx> wrote:

> You can do it like this:
>
> BEGIN;
> ALTER TABLE foo DROP CONSTRAINT your_constraint;
> ALTER TABLE foo ADD FOREIGN KEY ...;
> COMMIT;

The nice thing about the ALTER TABLE statement is that you can do it
in one command:

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

-- 
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general