| From: | "Rajesh Kumar Mallah" <mallah(dot)rajesh(at)gmail(dot)com> |
|---|---|
| To: | imad <immaad(at)gmail(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: transactional shared variable in postgresql |
| Date: | 2006-11-18 15:01:34 |
| Message-ID: | a97c77030611180701w3befaeb5udefe2c63bb93e27d@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
hi,
We do not want to modify our apps for doing auditing.
we are considering table level auditing
auditrail http://gborg.postgresql.org/project/audittrail/projdisplay.php
seems to be doing a good job. i just need to access the "username"
that starts the transaction in webapp from the trigger in audittrail.
basically we want to log selected tables of database without
modifying our web application code.
is it possible to get transaction id (XID) for current transaction ?
should it be used ? sorry for ignorance but i read some discouraging
remarks regarding using it in apps as it is an internal stuff.
regds
mallah.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rajesh Kumar Mallah | 2006-11-18 17:32:33 | Re: Random() |
| Previous Message | imad | 2006-11-18 13:46:02 | Re: transactional shared variable in postgresql |