Re: Custom session variables?
От | Adam Rich |
---|---|
Тема | Re: Custom session variables? |
Дата | |
Msg-id | 048a01c75d15$cb4ac5c0$6400a8c0@dualcore обсуждение исходный текст |
Ответ на | Re: Custom session variables? (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Custom session variables?
|
Список | pgsql-general |
Any way to pull the value of a config variable into a pl/pgsql variable? > -----Original Message----- > From: Tom Lane [mailto:tgl@sss.pgh.pa.us] > Sent: Friday, March 02, 2007 3:46 PM > To: David Fetter > Cc: Adam Rich; pgsql-general@postgresql.org > Subject: Re: [GENERAL] Custom session variables? > > > David Fetter <david@fetter.org> writes: > > On Fri, Mar 02, 2007 at 01:53:28PM -0600, Adam Rich wrote: > >> Is there any way to define custom variables per session scope? > > > You can have them in PL/Perl(U), PL/Tcl(U) and PL/PythonU and other > > such PLs, and you can create SQL accessors for them. > > Another possibility is the "customized GUC options" route: > you can take > advantage of the fact that the backend will let you set variables that > don't exist yet, if they are in a namespace that postgresql.conf says > is OK. > http://www.postgresql.org/docs/8.2/static/runtime-config-custom.html > This approach probably doesn't scale nicely to a whole lotta values, > but for a dozen or so strings it'd work well enough. > > regards, tom lane >
В списке pgsql-general по дате отправления: