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

From Greg Stark
Subject Re: Should SET ROLE inherit config params?
Date
Msg-id 4136ffa0903111444r7410226amcd66d4d205d0b2a5@mail.gmail.com
Whole thread Raw
In response to Re: Should SET ROLE inherit config params?  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Should SET ROLE inherit config params?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Wed, Mar 11, 2009 at 9:45 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
>
> On Wed, 2009-03-11 at 14:27 -0700, Josh Berkus 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?

Well for one thing pg_dump uses SET ROLE extensively and it sets
parameters assuming they'll stay set

--
greg


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Should SET ROLE inherit config params?
Next
From: Bernd Helmle
Date:
Subject: Re: Should SET ROLE inherit config params?