Re: altering foreign keys - Mailing list pgsql-general

From Adam Rich
Subject Re: altering foreign keys
Date
Msg-id 008b01c85d35$1b5b7e90$52127bb0$@r@sbcglobal.net
Whole thread Raw
In response to altering foreign keys  ("Adam Rich" <adam.r@sbcglobal.net>)
List pgsql-general
> In my database, I have a core table that nearly all other tables
> key against.  Now I need to adjust all of those foreign keys to
> add a "on update cascade" action.  Is there a way to alter the
> existing keys? (it didn't jump out at me in the manual)
>

Would it be possible to modify confupdtype in pg_constraint ?



pgsql-general by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: altering foreign keys
Next
From: "hjenkins"
Date:
Subject: CSV options in COPY