Should SET ROLE inherit config params?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Should SET ROLE inherit config params?
Date: 2009-03-11 21:27:51
Message-ID: 49B82CD7.20802@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2009-03-11 21:44:47 Re: Should SET ROLE inherit config params?
Previous Message Tom Lane 2009-03-11 20:38:50 Broken stuff in new dtrace probes