Re: Totally weird behaviour in org.postgresql.Driver

> 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