Postgres Pro
Downloads
Home   >   mailing lists

Re: Add ON UPDATE CASCADE to an existing table - Mailing list pgsql-novice

From Sean Davis
Subject Re: Add ON UPDATE CASCADE to an existing table
Date
Msg-id D6EAEEE4-2412-11D9-8BC9-000A95D7BA10@mail.nih.gov
Whole thread Raw
In response to Add ON UPDATE CASCADE to an existing table  ("Matt Arnilo S. Baluyos" <mbaluyos@sni.ph>)
List pgsql-novice
Tree view 
On Oct 22, 2004, at 2:50 AM, Matt Arnilo S. Baluyos wrote:
>
> how do i add an ON UPDATE/DELETE CASCADE constraint to an existing
> table?

Do you mean a foreign key constraint?  I think this may help.

http://www.postgresql.org/docs/current/static/sql-altertable.html

Sean

pgsql-novice by date:

Previous
From: "Matt Arnilo S. Baluyos"
Date:
Subject: Add ON UPDATE CASCADE to an existing table
Next
From: Sean Davis
Date:
Subject: Where clause efficiency using "IN"