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

From Josh Berkus
Subject Should SET ROLE inherit config params?
Date
Msg-id 49B82CD7.20802@agliodbs.com
Whole thread Raw
Responses Re: Should SET ROLE inherit config params?  (Simon Riggs <simon@2ndQuadrant.com>)
Re: Should SET ROLE inherit config params?  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
All,

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.

--Josh


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: gcc: why optimize for size flag is not the default
Next
From: Simon Riggs
Date:
Subject: Re: Should SET ROLE inherit config params?