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>
full-imp-alter-user-v1.patch.gz
Description: GNU Zip compressed data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
