Horton

Re: Should SET ROLE inherit config params?

Gregory Stark <stark@enterprisedb.com>

View thread View on postgr.es
From: Gregory Stark <stark@enterprisedb.com>
To: Guillaume Smet <guillaume.smet@gmail.com>
Cc: Josh Berkus <josh@agliodbs.com>, Simon Riggs <simon@2ndquadrant.com>, Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers@postgresql.org
Date: 2009-03-13T10:52:05Z
Lists: pgsql-hackers 
Guillaume Smet <guillaume.smet@gmail.com> writes:

> On Fri, Mar 13, 2009 at 2:39 AM, Josh Berkus <josh@agliodbs.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!