Skip site navigation (1) Skip section navigation (2)

Re: Totally weird behaviour in org.postgresql.Driver

From: "Peter" <peter(at)greatnowhere(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Totally weird behaviour in org.postgresql.Driver
Date: 2009-03-18 10:13:06
Message-ID: 49c0c935$0$1343$834e42db@reader.greatnowhere.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
> Yes, that is what I was suggesting in my previous post.  From an old 
> thread titled "can I define own variables?":
>
> =======
> To do this, you need to set custom_variable_classes in postgresql.conf,
> perhaps
>     custom_variable_classes = uservars
>
> and then you can do things like
>
>     SET uservars.foo = whatever;
>     SHOW uservars.bar;
> ======
>
> So, you can use pooled connections for scalability.  After you retrieve a 
> connection, set your user variable to contain the end user identifier. 
> Then you can retrieve it as necessary (e.g., in a trigger) for the 
> duration of the connection.


Excellent suggestion! Thanks a lot!

Peter 



In response to

pgsql-jdbc by date

Next:From: nenad.jaksicDate: 2009-03-20 11:06:36
Subject: Log4j Appender
Previous:From: Oliver JowettDate: 2009-03-18 09:20:52
Subject: Re: NoClassDefFoundErrors

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group