Cascade on update statement, not on table definition - Mailing list pgsql-admin

From webmaster@peladeiro.com.br
Subject Cascade on update statement, not on table definition
Date
Msg-id 200302052123.h15LNcK05573@pipobox.peladeiro.com.br
Whole thread Raw
List pgsql-admin
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? 

Tks
Felipe Nascimento

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problem with VACUUM
Next
From: Geoffrey Wossum
Date:
Subject: Problems upgrading from 7.1.3