Re: Should SET ROLE inherit config params?

From: Bernd Helmle <mailings(at)oopsware(dot)de>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Should SET ROLE inherit config params?
Date: 2009-03-11 21:56:10
Message-ID: 6F2075F6E5E9EF1CCB2EFB40@teje
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

--On Mittwoch, März 11, 2009 21:45:00 +0000 Simon Riggs
<simon(at)2ndQuadrant(dot)com> wrote:

>> 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?

I had exactly the same intention yesterday. Maybe something along the line
of su - is what we want, thus expanding such a functionality with an
optional argument to SET ROLE.

--
Thanks

Bernd

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2009-03-11 23:50:07 Re: Broken stuff in new dtrace probes
Previous Message Simon Riggs 2009-03-11 21:45:00 Re: Should SET ROLE inherit config params?