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

Поиск
Список
Период
Сортировка
От Guy Rouillier
Тема Re: Session variables (how do I pass session data to a function)
Дата
Msg-id 48FD12AE.1010808@burntmail.com
обсуждение исходный текст
Ответ на Session variables (how do I pass session data to a function)  ("Philip W. Dalrymple" <pwd@mdtsoft.com>)
Ответы Re: Session variables (how do I pass session data to a function)  ("Philip W. Dalrymple" <pwd@mdtsoft.com>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump is ignoring my pgpass file
Следующее
От: "Pavel Stehule"
Дата:
Сообщение: Re: Can PL/PGSQL function return multiple SETOFs