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 defined the 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 like that? Or do I need to redefine my tables, or the constraints? Tks Felipe Nascimento ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
