Re: update to alter user mapping example
От
Peter Eisentraut
Тема
Re: update to alter user mapping example
Дата
Msg-id
4cd43ca8-d66d-1811-e51f-3c6780d91e21@2ndquadrant.com
Ответ на
update to alter user mapping example (gabrielle)
Список
Дерево обсуждения
update to alter user mapping example gabrielle <gorthx@gmail.com>
Re: update to alter user mapping example Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
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
В списке pgsql-docs по дате отправления