Re: altering foreign keys

From: "Adam Rich" <adam(dot)r(at)sbcglobal(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: altering foreign keys
Date: 2008-01-22 20:26:44
Message-ID: 008b01c85d35$1b5b7e90$52127bb0$@r@sbcglobal.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ?

Browse pgsql-general by date

  From Date Subject
Next Message hjenkins 2008-01-22 22:29:41 CSV options in COPY
Previous Message Richard Broersma Jr 2008-01-22 19:33:54 Re: altering foreign keys