Postgres Pro
Downloads
Home   >   mailing lists

Thread: Add ON UPDATE CASCADE to an existing table

Add ON UPDATE CASCADE to an existing table

From
"Matt Arnilo S. Baluyos"
Date:
hello everyone,

how do i add an ON UPDATE/DELETE CASCADE constraint to an existing table?

Re: Add ON UPDATE CASCADE to an existing table

From
Sean Davis
Date:
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