Re: Determining caller of a function (due to a cascaded FK constraint?)

"Lenorovitz, Joel" <Joel.Lenorovitz@usap.gov> 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