Subject: Re: update to alter user mapping example
To: gabrielle <gorthx@gmail.com>, pgsql-docs@postgresql.org
References: 
 <CAHRs-_fZtrK+D923k_+L27O5ARN_cR=zdBkmpsB9XBHGgsVFVw@mail.gmail.com>
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Organization: 2ndQuadrant
Message-ID: <4cd43ca8-d66d-1811-e51f-3c6780d91e21@2ndquadrant.com>
Date: Tue, 20 Sep 2016 13:12:53 -0400
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:45.0)
 Gecko/20100101 Thunderbird/45.3.0
MIME-Version: 1.0
In-Reply-To: 
 <CAHRs-_fZtrK+D923k_+L27O5ARN_cR=zdBkmpsB9XBHGgsVFVw@mail.gmail.com>
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

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


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs