> 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,
> 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!
In response to
pgsql-jdbc by date
|Next:||From: nenad.jaksic||Date: 2009-03-20 11:06:36|
|Subject: Log4j Appender|
|Previous:||From: Oliver Jowett||Date: 2009-03-18 09:20:52|
|Subject: Re: NoClassDefFoundErrors|