From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: gabrielle <gorthx@gmail.com>
To: pgsql-docs@postgresql.org
Subject: Re: update to alter user mapping example
Date: Tue, 20 Sep 2016 13:12:53 -0400
Message-ID: <4cd43ca8-d66d-1811-e51f-3c6780d91e21@2ndquadrant.com> (raw)
In-Reply-To: <CAHRs-_fZtrK+D923k_+L27O5ARN_cR=zdBkmpsB9XBHGgsVFVw@mail.gmail.com>
References: <CAHRs-_fZtrK+D923k_+L27O5ARN_cR=zdBkmpsB9XBHGgsVFVw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: peter.eisentraut@2ndquadrant.com, gorthx@gmail.com
Subject: Re: update to alter user mapping example
In-Reply-To: <4cd43ca8-d66d-1811-e51f-3c6780d91e21@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox