"Lenorovitz, Joel" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match