oddity with ALTER ROLE/USER

Поиск
Список
Период
Сортировка
От Joe Conway
Тема oddity with ALTER ROLE/USER
Дата
Msg-id 27cbc852-5f53-9637-24da-92c1d46fd69e@joeconway.com
обсуждение исходный текст
Ответы Re: oddity with ALTER ROLE/USER  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
I noticed that ALTER ROLE/USER succeeds even when called without any
options:

postgres=# alter user foo;
ALTER ROLE
postgres=# alter role foo;
ALTER ROLE
postgres=# alter group foo;
ERROR:  syntax error at or near ";"
LINE 1: alter group foo;

That seems odd, does nothing useful, and is inconsistent with, for
example, ALTER GROUP as shown above.

Proposed patch attached.

Comments/thoughts?

Joe

--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development

Вложения

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: CTE Changes in PostgreSQL 12, can we have a GUC to get old behavior
Следующее
От: Tom Lane
Дата:
Сообщение: Re: CTE Changes in PostgreSQL 12, can we have a GUC to get old behavior