Re: Should SET ROLE inherit config params?

From: Greg Stark <stark(at)enterprisedb(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Should SET ROLE inherit config params?
Date: 2009-03-11 21:44:47
Message-ID: 4136ffa0903111444r7410226amcd66d4d205d0b2a5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Mar 11, 2009 at 9:45 PM, Simon Riggs <simon(at)2ndquadrant(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2009-03-11 21:45:00 Re: Should SET ROLE inherit config params?
Previous Message Josh Berkus 2009-03-11 21:27:51 Should SET ROLE inherit config params?