oddity with ALTER ROLE/USER

From: Joe Conway <mail(at)joeconway(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: oddity with ALTER ROLE/USER
Date: 2019-02-22 21:13:24
Message-ID: 27cbc852-5f53-9637-24da-92c1d46fd69e@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Attachment Content-Type Size
alter-role-00.patch text/x-patch 563 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2019-02-22 21:14:23 Re: CTE Changes in PostgreSQL 12, can we have a GUC to get old behavior
Previous Message Robert Haas 2019-02-22 21:08:14 Re: CTE Changes in PostgreSQL 12, can we have a GUC to get old behavior