Re: Alter table to "on update cascade"

On 11/17/2010 08:32 AM, Aram Fingal wrote:
> I have a table where I should have declared a foreign key with ON UPDATE CASCADE and didn't.  Now I want to fix that.
From the documentation on www.postgresql.org, about ALTER TABLE it's not at all clear how to do this or even whether
youcan do this. 
>
> -Aram

http://www.postgresql.org/docs/9.0/interactive/sql-altertable.html

ADD table_constraint

     This form adds a new constraint to a table using the same syntax as
CREATE TABLE.

--
Adrian Klaver
adrian.klaver@gmail.com