| 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: | Whole Thread | Raw Message | 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 |