From: imad <immaad@gmail.com>
To: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: transactional shared variable in postgresql
Date: Sun, 19 Nov 2006 00:45:13 +0500
Message-ID: <1f30b80c0611181145n7ba19abbtd85c82789a281ec8@mail.gmail.com> (raw)
In-Reply-To: <a97c77030611181115p58f7f11eh666b66e86d6c5fcd@mail.gmail.com>
References: <a97c77030611180430p764dac32ue19ade554ec80cbe@mail.gmail.com>
<532.1163875210@sss.pgh.pa.us>
<a97c77030611181115p58f7f11eh666b66e86d6c5fcd@mail.gmail.com>
Check this one
http://archives.postgresql.org/pgsql-patches/2004-04/msg00280.php
I have not personally worked on what is described in this page but someone will
correct you in the community if anything is going wrong here.
--Imad
www.EnterpriseDB.com
On 11/19/06, Rajesh Kumar Mallah <mallah.rajesh@gmail.com> wrote:
>
>
> On 11/19/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > "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
>
> Hi,
>
> wouldnt' it affect the connection pooling , i am using DBI::Cache and
> mod_perl ?
>
> > needs.
> >
> http://www.postgresql.org/docs/8.1/static/runtime-config-custom.html
>
>
> i dont think i understand the usage properly,
>
> i did the below postgresql.conf
> custom_variable_classes = 'general' # list of custom variable
> class names
> general.employee = ''
>
> am i supposed to see the variable general.employee when i do "show all " ?
> i did not see it in fact!
>
> my question is how can i set it and read it
>
> regds
> Mallah.
>
>
> > 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: immaad@gmail.com, mallah.rajesh@gmail.com, tgl@sss.pgh.pa.us
Subject: Re: transactional shared variable in postgresql
In-Reply-To: <1f30b80c0611181145n7ba19abbtd85c82789a281ec8@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