Re: ALTER ROLE SET/RESET for multiple options

Поиск
Список
Период
Сортировка
От Masahiko Sawada
Тема Re: ALTER ROLE SET/RESET for multiple options
Дата
Msg-id CAD21AoDdduX80nmz2BtO9vxnQH7DKMfkdQ0kPo5j143CDWg-ZQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ALTER ROLE SET/RESET for multiple options  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: ALTER ROLE SET/RESET for multiple options  (Robert Haas <robertmhaas@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: pglogical - logical replication contrib module
Следующее
От: Rushabh Lathia
Дата:
Сообщение: Re: Should PostgresFDW ImportForeignSchema should import the remote table default expression?