Is there a way to set a session global variable in PostgreSQL? The only
thing I see are examples of setting config variables. What I would like
to do is this:
Have a table "insertedby" or something that has
created_object oid,
created_by_user oid,
creation_date datetime
Then have a procedure, so that any table that wanted to record who
inserted which record could just use that procedure as an insert
trigger. The trigger would simply read the "current_user" session
variable (which the client had presumably set upon connection) and use it
to populate the "created_by_user" field.
However, the only way I can see to implement this is to have session
global variables. Is there a way to fake session global variables with a
table? Any comments would be appreciated.
Jon
johnnyb6@sdf.lonestar.org
SDF Public Access UNIX System - http://sdf.lonestar.org