From: Tom Lane <tgl@sss.pgh.pa.us>
To: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: transactional shared variable in postgresql
Date: Sat, 18 Nov 2006 13:40:10 -0500
Message-ID: <532.1163875210@sss.pgh.pa.us> (raw)
In-Reply-To: <a97c77030611180430p764dac32ue19ade554ec80cbe@mail.gmail.com>
References: <a97c77030611180430p764dac32ue19ade554ec80cbe@mail.gmail.com>
"Rajesh Kumar Mallah" <mallah.rajesh@gmail.com> writes:
> In our webapps, we use the same username to connect to the database
> for all kind of updates. Hence we are not able to makeout whoo modified
> what . However at application level we have different "userid" for different
> users of the system. we want to somehow pass this "userid" to the databasee
> server and accesss it from the triggers that implement the audit functions.
Perhaps it would be better to make your "userid" be the actual database
user? But anyway, the custom GUC variable facility might serve your
needs.
http://www.postgresql.org/docs/8.1/static/runtime-config-custom.html
regards, tom lane
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: tgl@sss.pgh.pa.us, mallah.rajesh@gmail.com
Subject: Re: transactional shared variable in postgresql
In-Reply-To: <532.1163875210@sss.pgh.pa.us>
* 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