From: | Gregory Stark <stark(at)enterprisedb(dot)com> |
---|---|
To: | Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com> |
Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Should SET ROLE inherit config params? |
Date: | 2009-03-13 10:52:05 |
Message-ID: | 87bps566ga.fsf@oxford.xeocode.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com> writes:
> On Fri, Mar 13, 2009 at 2:39 AM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
>> SET ROLE special WITH SETTINGS
>>
>> ... or similar; I'd need to find an existing keyword which works.
>
> Perhaps something like "SET ROLE special NEW SESSION;".
>
> It solves a problem mentioned by Tom as it's very clear that it's a
> new session so when you reset the settings to what they were at
> session start, you take the default settings of special.
So this is just syntactic sugar for
SET ROLE;
RESET ALL;
Or is it more or less?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's RemoteDBA services!
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Bartunov | 2009-03-13 11:56:18 | Re: GIN, partial matches, lossy bitmaps |
Previous Message | Guillaume Smet | 2009-03-13 08:25:11 | Re: Should SET ROLE inherit config params? |