Guillaume Smet <guillaume.s...@gmail.com> writes: > On Fri, Mar 13, 2009 at 2:39 AM, Josh Berkus <j...@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! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
