change alter user to be a true alias for alter role

From: Jov <amutu(at)amutu(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: change alter user to be a true alias for alter role
Date: 2014-01-20 14:31:51
Message-ID: CADyrUxMv-tvSBV7mTtcs+qEdNy6xj1+KRtzfowVuHdJC5mGjfg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

the doc say:

> ALTER USER is now an alias for ALTER ROLE<http://www.postgresql.org/docs/devel/static/sql-alterrole.html>
> .

but alter user lack the following format:

> ALTER ROLE name [ IN DATABASE database_name ] SET configuration_parameter{ TO | = } {
> value | DEFAULT }
> ALTER ROLE { name | ALL } [ IN DATABASE database_name ] SET
> configuration_parameter FROM CURRENT
> ALTER ROLE { name | ALL } [ IN DATABASE database_name ] RESET
> configuration_parameter
> ALTER ROLE { name | ALL } [ IN DATABASE database_name ] RESET ALL

attach patch add the per database set for alter user:
ALTER
USER
name [ IN DATABASE database_name ] SET configuration_parameter { TO | = }
{ value | DEFAULT }
ALTER
USER
{ name | ALL } [ IN DATABASE database_name ] SET configuration_parameter FROM
CURRENT
ALTER
USER
{ name | ALL } [ IN DATABASE database_name ] RESET configuration_parameter
ALTER
USER
{ name | ALL } [ IN DATABASE database_name ] RESET ALL

this make alter user a true alias for alter role.

Jov
blog: http:amutu.com/blog <http://amutu.com/blog>

Attachment Content-Type Size
full-imp-alter-user-v1.patch.gz application/x-gzip 591 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mel Gorman 2014-01-20 14:46:06 Re: [Lsf-pc] Linux kernel impact on PostgreSQL performance
Previous Message Mel Gorman 2014-01-20 14:27:03 Re: [Lsf-pc] Linux kernel impact on PostgreSQL performance