Re: Update cascade on stmt, not on table definition - Mailing list pgsql-admin

From Robert Treat
Subject Re: Update cascade on stmt, not on table definition
Date
Msg-id 1044543521.22810.135.camel@camel
Whole thread Raw
In response to Update cascade on stmt, not on table definition  (Felipenasc@aol.com)
List pgsql-admin
On Thu, 2003-02-06 at 07:22, Felipenasc@aol.com wrote:
> Hi,
>
> I saw I can define a table that specifies a ON UPDATE CASCADE for a Foreign Key.
>
> I have a lot of tables with FK´s, and a lot of others with others FK's for the firts ones, and so on, and I haven´t
definedthe ON CASCADE clause on the FK´s tables.  
> Now I need to update a primary key on the "mother" table.
>
> Is there a way to execute a stmt like 'update tbl set id_field=NEW_ID where id_field=OLD_ID on CASCADE', or something
likethat? Or do I need to redefine my tables, or the constraints? 
>

There is no way to do this in an sql statement. You might be able to
modify the constraints to update instead of delete, though the syntax to
do this escapes me (perhaps someone else can post it?). Otherwise you'll
have to drop and recreate the fk triggers or recreate the table.

Robert Treat



pgsql-admin by date:

Previous
From: Robert Treat
Date:
Subject: Re:
Next
From: Tom Lane
Date:
Subject: Re: Duplicate indexes found in the postgres Database