Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 2A6C99F9FB1 for ; Sat, 18 Nov 2006 15:45:24 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 66447-04 for ; Sat, 18 Nov 2006 19:45:19 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.187]) by postgresql.org (Postfix) with ESMTP id 7AA5B9F98F8 for ; Sat, 18 Nov 2006 15:45:15 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id x4so1949205nfb for ; Sat, 18 Nov 2006 11:45:14 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=DDyTqXa/B+DZo1OZypWoi3wwSnhIY9PONbmYDb7dKgUVHNsLzTG+jbD+yC94eB4koxXEMwYDvpcF7cTc2I6Djfp5PmHT9qy5vYVU8YYijq/u3AOc15XOc0odkAiKpSkyqBjdAK6T+HQtg8eqGQ6VdDWFT0x8/YHTlSDO5j2uOBg= Received: by 10.82.118.2 with SMTP id q2mr384328buc.1163879113973; Sat, 18 Nov 2006 11:45:13 -0800 (PST) Received: by 10.82.161.3 with HTTP; Sat, 18 Nov 2006 11:45:13 -0800 (PST) Message-ID: <1f30b80c0611181145n7ba19abbtd85c82789a281ec8@mail.gmail.com> Date: Sun, 19 Nov 2006 00:45:13 +0500 From: imad To: "Rajesh Kumar Mallah" Subject: Re: transactional shared variable in postgresql Cc: "Tom Lane" , pgsql-sql@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <532.1163875210@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/202 X-Sequence-Number: 26854 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 wrote: > > > On 11/19/06, Tom Lane wrote: > > "Rajesh Kumar Mallah" 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 > > > >