Re: update to alter user mapping example

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: gabrielle <gorthx(at)gmail(dot)com>, pgsql-docs(at)postgresql(dot)org
Subject: Re: update to alter user mapping example
Date: 2016-09-20 17:12:53
Message-ID: 4cd43ca8-d66d-1811-e51f-3c6780d91e21@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Peter Eisentraut 2016-09-20 17:31:58 Re: Obsolete warning on Python 2.4
Previous Message Takeshi Ideriha 2016-09-20 10:56:02 Re: description of 'make world' in installation.sgml