From: | "Lenorovitz, Joel" <Joel(dot)Lenorovitz(at)usap(dot)gov> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org>, <pgsql-novice(at)postgresql(dot)org> |
Subject: | Determining caller of a function (due to a cascaded FK constraint?) |
Date: | 2006-10-09 17:59:05 |
Message-ID: | 7119BB016BDF6445B20A4B9F14F50B2D44A8A0@WILSON.usap.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | George Pavlov | 2006-10-09 18:13:23 | postgres query log analysis? |
Previous Message | Tom Lane | 2006-10-09 14:36:26 | Re: Fwd: pg_dump VS alter database ... set search_path ... |
From | Date | Subject | |
---|---|---|---|
Next Message | Saranya Sivakumar | 2006-10-09 19:06:51 | pg_config not found |
Previous Message | jsmesegue | 2006-10-09 10:46:44 | ODBC Connection from Cognos Framework Manager to postgresql |