| From: | Fabio Nanni <f(dot)nanni(at)albourne(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | triggers and actions tree |
| Date: | 2000-12-04 12:39:34 |
| Message-ID: | 3A2B9086.4A9B2B56@albourne.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hello all,
I am new to postgreSQL.
When I perform an action on a psql database (e.g. insert into a table),
some more action could be induced, via trigger firing:
- is it possible to know at any time the exact action chain?
- is it possible to know at any time if the control is inside a
trigger (and which one)?
Sorry, I tried to search in www.postgresql.org but I wasn't able to
find anything useful.
These questions arise because I'm trying to keep in sync two identical
psql databases; I have audited tables and an audit trail. I'm facing the
problem of recognising which actions in the trail were due to a trigger
firing, rather than explicitly commanded.
Thank you in advance
Fabio
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 2000-12-04 12:52:50 | Wrong FOR UPDATE lock type |
| Previous Message | Vince Vielhaber | 2000-12-04 11:37:23 | Re: beta testing version |