From: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
To: imad <immaad@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: transactional shared variable in postgresql
Date: Sat, 18 Nov 2006 20:31:34 +0530
Message-ID: <a97c77030611180701w3befaeb5udefe2c63bb93e27d@mail.gmail.com> (raw)
In-Reply-To: <1f30b80c0611180546p35332e82mb592bcd6a048576d@mail.gmail.com>
References: <a97c77030611180430p764dac32ue19ade554ec80cbe@mail.gmail.com>
<1f30b80c0611180546p35332e82mb592bcd6a048576d@mail.gmail.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mallah.rajesh@gmail.com, immaad@gmail.com
Subject: Re: transactional shared variable in postgresql
In-Reply-To: <a97c77030611180701w3befaeb5udefe2c63bb93e27d@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox