alter user and alter cmd do not have same functions

From: Jov <zhao6014(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: alter user and alter cmd do not have same functions
Date: 2012-02-28 11:04:58
Message-ID: CADyrUxMqe=WbByDcze9M1Owk6YGU7vNh3j=t+++UpLB8i52xgw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

for alter user,there is a description:

> ALTER USER is now an alias for ALTER ROLE.
>
so,people will think they are the same.but there are differences:

> ALTER USER *name* SET *configuration_parameter* { TO | = } { *value* |
> DEFAULT }

ALTER USER *name* SET *configuration_parameter* FROM CURRENT

ALTER USER *name* RESET *configuration_parameter*

ALTER USER *name* RESET ALL

and

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

ALTER ROLE *name* [ IN DATABASE *database_name* ] RESET *
> configuration_parameter*

ALTER ROLE *name* [ IN DATABASE *database_name* ] RESET ALL

I think we should either metion the differences in doc or make the have no
differences. It took some time to find the later today because I most time
use alter user and think it equel to alter role.

Browse pgsql-general by date

  From Date Subject
Next Message Andre Lopes 2012-02-28 11:07:47 How to get a signal from the database when a INSERT INTO is done?
Previous Message Tomas Vondra 2012-02-28 10:20:20 Re: "canceling autovacuum time"