Обсуждение: update to alter user mapping example

Поиск
Список
Период
Сортировка

update to alter user mapping example

От
gabrielle
Дата:
Hello!

The example for ALTER USER MAPPING is missing the action keyword (ADD|SET|DROP).

Since ADD is the default option, the given command attempts to add a user 'bob' to the already-existing user mapping 'bob', which throws an 'ERROR:  option "user" provided more than once'

Here's a working example that a) matches the description ("change password") and b) continues the steps started with the CREATE USER MAPPING example.

ALTER USER MAPPING FOR bob SERVER foo OPTIONS (SET password 'public');

I've attached a patch as well.

Thanks!

gabrielle
Вложения

Re: update to alter user mapping example

От
Peter Eisentraut
Дата:
On 8/24/16 9:07 PM, gabrielle wrote:
> The example for ALTER USER MAPPING is missing the action keyword
> (ADD|SET|DROP).
>
> Since ADD is the default option, the given command attempts to add a
> user 'bob' to the already-existing user mapping 'bob', which throws an
> 'ERROR:  option "user" provided more than once'
>
> Here's a working example that a) matches the description ("change
> password") and b) continues the steps started with the CREATE USER
> MAPPING example.
>
> ALTER USER MAPPING FOR bob SERVER foo OPTIONS (SET password 'public');
>
> I've attached a patch as well.

Fixed, thanks.

--
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services