"Lenorovitz, Joel" <Joel.Lenorovitz@xxxxxxxx> writes: > I want to have a trigger that will copy some data from a table in one > schema to an analogous table in another schema every time a record is > modified UNLESS the modification is the result of a cascaded foreign key > constraint. Sorry, there isn't any reasonable way for a trigger to tell that. regards, tom lane
