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