In article <459D4FA0.4020202@xxxxxxxxxxxx>, John McCawley <nospam@xxxxxxxxxxxx> 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@xxxxxxxxxxxx
