update to alter user mapping example - Mailing list pgsql-docs

From gabrielle
Subject update to alter user mapping example
Date
Msg-id CAHRs-_fZtrK+D923k_+L27O5ARN_cR=zdBkmpsB9XBHGgsVFVw@mail.gmail.com
Whole thread Raw
Responses Re: update to alter user mapping example  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-docs
Hello!

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.

Thanks!

gabrielle
Attachment

pgsql-docs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Docbook 5.x
Next
From: Bruce Momjian
Date:
Subject: Re: Incorrect 'literal' tags