Re: ALTER ROLE SET/RESET for multiple options - Mailing list pgsql-hackers

From Masahiko Sawada
Subject Re: ALTER ROLE SET/RESET for multiple options
Date
Msg-id CAD21AoDdduX80nmz2BtO9vxnQH7DKMfkdQ0kPo5j143CDWg-ZQ@mail.gmail.com
Whole thread Raw
In response to Re: ALTER ROLE SET/RESET for multiple options  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: ALTER ROLE SET/RESET for multiple options
List pgsql-hackers
On Sat, Feb 13, 2016 at 2:45 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Fri, Feb 12, 2016 at 1:35 PM, Payal Singh <payal@omniti.com> wrote:
>> The feature seems to work as described, but is it necessary to enclose multiple GUC settings in a parenthesis? This
seemsa deviation from the usual syntax of altering multiple settings separated with comma.
 
>
> Well, note that you can say:
>
> ALTER USER bob SET search_path = a, b, c;
>
> I'm not sure how the parentheses help exactly; it seems like there is
> an inherit ambiguity either way.
>

I thought it would be useful for user who wants to set several GUC
parameter for each user. Especially the case where changing logging
parameter for each user.
But it might not bring us fantastic usability.

Regards,

--
Masahiko Sawada



pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: pglogical - logical replication contrib module
Next
From: Rushabh Lathia
Date:
Subject: Re: Should PostgresFDW ImportForeignSchema should import the remote table default expression?