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 |
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 |