Re: Session variables (how do I pass session data to a function)

From: Guy Rouillier <guyr-ml1(at)burntmail(dot)com>
To: General Postgres Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Session variables (how do I pass session data to a function)
Date: 2008-10-20 23:22:22
Message-ID: 48FD12AE.1010808@burntmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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#FUNCTIONS-ADMIN-SET-TABLE

If you'd like to read a fuller discussion of this very topic, search for
a thread titled "can I define own variables" in the archives. I had to
do the same thing back then.

--
Guy Rouillier

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Fry 2008-10-21 00:22:24 statement_timeout by host?
Previous Message Tom Lane 2008-10-20 23:11:07 Re: pg_dump is ignoring my pgpass file