Re: oddity with ALTER ROLE/USER

Greetings, * Tom Lane (t...@sss.pgh.pa.us) wrote: > Joe Conway writes: > > 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: s

Re: oddity with ALTER ROLE/USER

On 2/22/19 4:19 PM, Tom Lane wrote: > Joe Conway writes: >> 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

Re: oddity with ALTER ROLE/USER

Joe Conway writes: > 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