Re: Any form of connection-level "session variable" ?

In article <459D4FA0.4020202@hardgeus.com>,
John McCawley <nospam@hardgeus.com> wrote:

% Is there any way I could establish this ID initially in some sort of
% connection-level variable, and from this point on reference that
% variable?

We do this sort of thing using a custom C function, but I've been
thinking lately you could use a custom variable class to do the same
thing.

Put
 custom_variable_classes = 'session'

in your postgresql.conf, and you can have
 set session.myid = 23;

then retrieve the value either by joining to pg_settings or using
 show session.myid;

You can perform per-user initialisation with
 alter user set session.myid = 23;

Which allows the value to persist between sessions.

I haven't done anything with this idea so I can't say how well it
works or whether there are downsides to it.
--

Patrick TJ McPhee
North York  Canada
ptjm@interlog.com