Re: transactional shared variable in postgresql
| От | Rajesh Kumar Mallah |
|---|---|
| Тема | Re: transactional shared variable in postgresql |
| Дата | |
| Msg-id | a97c77030611181115p58f7f11eh666b66e86d6c5fcd@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: transactional shared variable in postgresql (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: transactional shared variable in postgresql
|
| Список | pgsql-sql |
On 11/19/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Hi,
wouldnt' it affect the connection pooling , i am using DBI::Cache and mod_perl ?
i dont think i understand the usage properly,
i did the below postgresql.conf
custom_variable_classes = 'general' # list of custom variable class names
general.employee = ''
am i supposed to see the variable general.employee when i do "show all " ?
i did not see it in fact!
my question is how can i set it and read it
regds
Mallah.
"Rajesh Kumar Mallah" <mallah.rajesh@gmail.com> writes:
> In our webapps, we use the same username to connect to the database
> for all kind of updates. Hence we are not able to makeout whoo modified
> what . However at application level we have different "userid" for different
> users of the system. we want to somehow pass this "userid" to the databasee
> server and accesss it from the triggers that implement the audit functions.
Perhaps it would be better to make your "userid" be the actual database
user? But anyway, the custom GUC variable facility might serve your
Hi,
wouldnt' it affect the connection pooling , i am using DBI::Cache and mod_perl ?
needs.
http://www.postgresql.org/docs/8.1/static/runtime-config-custom.html
i dont think i understand the usage properly,
i did the below postgresql.conf
custom_variable_classes = 'general' # list of custom variable class names
general.employee = ''
am i supposed to see the variable general.employee when i do "show all " ?
i did not see it in fact!
my question is how can i set it and read it
regds
Mallah.
regards, tom lane
В списке pgsql-sql по дате отправления: