Re: ALTER ROLE SET/RESET for multiple options

Поиск
Список
Период
Сортировка
От Masahiko Sawada
Тема Re: ALTER ROLE SET/RESET for multiple options
Дата
Msg-id CAD21AoAH-onV+oJFCedRFE=fjfq1y8Uq1z+JFKTtaZY50qRzUQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ALTER ROLE SET/RESET for multiple options  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: ALTER ROLE SET/RESET for multiple options  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-hackers
On Wed, Feb 17, 2016 at 7:14 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Wed, Feb 17, 2016 at 3:22 PM, Masahiko Sawada <sawada.mshk@gmail.com> wrote:
>> 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?
Thisseems a 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.
>
> Yeah, it doesn't really seem like it's worth trying to figure out a
> syntax for this that can work.  It just doesn't buy us very much vs.
> issuing one ALTER COMMAND per setting.
>

Yeah, please mark this patch as 'rejected'.
If I can come up with another good idea, will post.

Regards,

--
Masahiko Sawada



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Ioseph Kim
Дата:
Сообщение: Re: Figures in docs
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: exposing pg_controldata and pg_config as functions