Re: Add ON UPDATE CASCADE to an existing table

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: "Matt Arnilo S(dot) Baluyos" <mbaluyos(at)sni(dot)ph>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Add ON UPDATE CASCADE to an existing table
Date: 2004-10-22 10:12:11
Message-ID: D6EAEEE4-2412-11D9-8BC9-000A95D7BA10@mail.nih.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Davide Negri 2004-10-22 13:52:36 Log
Previous Message Matt Arnilo S. Baluyos 2004-10-22 06:50:32 Add ON UPDATE CASCADE to an existing table