Re: PHP Web Auditing and Authorization

Поиск
Список
Период
Сортировка
От Bill Moran
Тема Re: PHP Web Auditing and Authorization
Дата
Msg-id 20101103111613.3bc5cade.wmoran@potentialtech.com
обсуждение исходный текст
Ответ на Re: PHP Web Auditing and Authorization  ("Massa, Harald Armin" <chef@ghum.de>)
Ответы Re: PHP Web Auditing and Authorization  (Gabriel Dinis <gabriel.dinis@vigiesolutions.com>)
Список pgsql-general
In response to "Massa, Harald Armin" <chef@ghum.de>:

> Bill,
>
> >
> >
> > We got this same kind of thing working by using PostgreSQL env variables.
> > First, set custom_variable_classes in your postgresql.conf.  You can then
> > use the SET command to set variables of that class, and use them in your
> > functions:
> >
> > that is an interesting hack. Just googled up
>
> http://developer.postgresql.org/pgdocs/postgres/runtime-config-custom.html
>
> and now I am wondering, where did you get your confidence  that those
> variables are bound to sessions and NOT bound to server instances? My
> reading of that documentation let me stay in the assumption, those variables
> are the same across server instances....

huh?

Those variables are bound to database session.  Which means each PHP
process needs to set that variable shortly after establishing the
database connection, and before running any queries that require it.
Otherwise, PHP persistent connections my have values from previous
scripts, and non-persistent connections will have the values unset.

We set all the values we use in our session startup code, which always
runs at the beginning of script execution, and is guaranteed to know
the values because it's reading them from the session.

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/

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

Предыдущее
От: "Massa, Harald Armin"
Дата:
Сообщение: Re: PHP Web Auditing and Authorization
Следующее
От: RP Khare
Дата:
Сообщение: How to configure pgsql in such a way that it is always recoverable?