Determining caller of a function (due to a cascaded FK constraint?)
Greetings,
For reasons a little too complicated to get into off the bat, I am
wondering what the most effective way is to determine by whom or how a
particular action or function call was initiated. To shed more light, 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. My hunch is that the answer somehow includes using data in
pg_class and/or pg_proc, but I haven't quite pieced it all together.
Does anyone have any recommendations on how to go about this?
Thanks,
JL
"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
On Mon, 09 Oct 2006 16:34:09 -0400
Tom Lane <tgl@sss.pgh.pa.us> wrote:
"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.
thx. I was wondering if *I* wasn't able to find one.
I had the same need around a month ago I ended up in adding metadata to tables and "simulating" triggers with a dynamically generated sp.
So I could define "deferred" referential integrity nearby table definitions as I was used with pk/fk triggers.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it