Re: Should SET ROLE inherit config params? - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Should SET ROLE inherit config params?
Date
Msg-id 1236807900.28644.211.camel@ebony.2ndQuadrant
Whole thread Raw
In response to Should SET ROLE inherit config params?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Should SET ROLE inherit config params?
Re: Should SET ROLE inherit config params?
List pgsql-hackers
On Wed, 2009-03-11 at 14:27 -0700, Josh Berkus wrote:

> I was just noticing that doing SET ROLE changes the current session's 
> priviledges, but not any runtime configuration parameters (like work_mem 
> or statement_timeout) associated with the new role.
> 
> This is as documented (although I want to add a line to SET ROLE docs) 
> but is it the behavior we want?  I for one would like SET ROLE to change 
> runtime configs.

Sounds good to me, but you may want to explore what problems that might
cause so we can avoid screwing up. Perhaps it could be an option?

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support



pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Should SET ROLE inherit config params?
Next
From: Greg Stark
Date:
Subject: Re: Should SET ROLE inherit config params?