On 8/24/16 9:07 PM, gabrielle wrote:
> The example for ALTER USER MAPPING is missing the action keyword
> 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.
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Sent via pgsql-docs mailing list (email@example.com)
To make changes to your subscription: