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. -- Guillaume -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers