Is there a way to set a session global variable in PostgreSQL?
The only
thing I see are examples of setting config variables.
Not sure if session variables are your best solution, but here's how you
implement them:
-- Warning: this defines a global variable in the tcl interpretor.
This coul
Yes, that's perfect! Actually, I was thinking of a real user, but more
in the fashion of "pretend" users. If you've ever used Oracle apps, it
would be like an apps user, not the user "apps".
Anyway, that's an excellent idea. Thank you much!
Jon
[EMAIL PROTECTED]
SDF Public Access UNIX System
Jonathan Bartlett <[EMAIL PROTECTED]> writes:
> 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.
You could do it with temp tables: the same temp table name
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,
