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