thanks for everyone's help on this.
- Original Message -
From: "Guy Rouillier" <[EMAIL PROTECTED]>
To: "General Postgres Mailing List"
Sent: Monday, October 20, 2008 7:22:22 PM GMT -05:00 US/Canada Eastern
Subject: Re: [GENERAL] Session variables (how do I pa
Philip W. Dalrymple wrote:
What I want to do is to add to this another field that will be NULL
UNLESS the session sets a value to the "user" for that the middle-wear
system is acting for.
This can be done via a setting. See
http://www.postgresql.org/docs/8.2/static/functions-admin.html#FUNC
Philip,
"session variables" is the perfect name for this kind of use; and
googling it up some times ago lead me to
a) a temp table implementation
b) some shared memory implementation
of these I can present you with a), written to store an integer
user-ID; you can adjust it accordingly:
CREATE O
I have a question on how to do something with Postgres that I think
of by the name of "Session Variables".
What I want to do is build a table that will be filled in by a trigger,
it will contains three fields in addition to the fields in the table
that causes the trigger that will contain the ti
