| 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: | Whole Thread | Raw Message | 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 |