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

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 11 of 27 | next ›
Discussion Overview
grouppgsql-hackers @
categoriespostgresql
postedMar 11, '09 at 9:28p
activeMar 28, '09 at 7:31p
posts27
users9
websitepostgresql.org...
irc#postgresql

People

Translate

site design / logo © 2021 Grokbase