Postgres Pro
Downloads
Home   >   mailing lists

Re: Determining caller of a function (due to a cascaded FK constraint?) - Mailing list pgsql-general

From Tom Lane
Subject Re: Determining caller of a function (due to a cascaded FK constraint?)
Date
Msg-id 6644.1160426049@sss.pgh.pa.us
Whole thread Raw
In response to Determining caller of a function (due to a cascaded FK constraint?)  ("Lenorovitz, Joel" <Joel.Lenorovitz@usap.gov>)
Responses Re: Determining caller of a function (due to a cascaded
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: "pobox@verysmall.org"
Date:
Subject: plpgsql handling a set of values
Next
From: Ivan Sergio Borgonovo
Date:
Subject: Re: Determining caller of a function (due to a cascaded