Re: patch: shared session variables - Mailing list pgsql-hackers

From Robert Haas
Subject Re: patch: shared session variables
Date
Msg-id CA+Tgmoa0uMYyB8EZ9kAw_iUsjyH6g668cSOJzAOUqm9NMW6hsQ@mail.gmail.com
Whole thread Raw
In response to Re: patch: shared session variables  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: patch: shared session variables
List 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 by date:

Previous
From: Robert Haas
Date:
Subject: Re: Wiki link for max_connections? (Fwd: Re: [ADMIN] PostgreSQL oom_adj postmaster process to -17)
Next
From: Robert Haas
Date:
Subject: Re: Proof of concept: auto updatable views