Re: patch: shared session variables

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: patch: shared session variables
Дата
Msg-id CA+Tgmoa0uMYyB8EZ9kAw_iUsjyH6g668cSOJzAOUqm9NMW6hsQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: patch: shared session variables  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: patch: shared session variables
Список pgsql-hackers
On Thu, Aug 30, 2012 at 2:18 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> 2012/8/30 Robert Haas <robertmhaas@gmail.com>:
>> On Tue, Aug 14, 2012 at 3:46 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
>>> patch that implements "shared" client/server session variables
>>
>> I don't really see what we can do with this that we can't do without this.
>
> a motivation for this patch was discussion about parametrised DO
> statement - and simple possibility of access to host variables (psql)
> variables from server - PL scripts.
>
> It is based on Tom's and Magnus's ideas - it is secure, because only
> variables explicitly mentioned in shared namespace are "shared".

Sure, but you could get to the same place by issuing a SET command for
just the particular variable you want to use with DO.  You don't
really need a magic facility for it.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Wiki link for max_connections? (Fwd: Re: [ADMIN] PostgreSQL oom_adj postmaster process to -17)
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Proof of concept: auto updatable views