> 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