update to alter user mapping example

From: gabrielle <gorthx(at)gmail(dot)com>
To: pgsql-docs(at)postgresql(dot)org
Subject: update to alter user mapping example
Date: 2016-08-25 01:07:20
Message-ID: CAHRs-_fZtrK+D923k_+L27O5ARN_cR=zdBkmpsB9XBHGgsVFVw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
0001-correct-ALTER-USER-MAPPING-example.patch text/x-patch 969 bytes

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2016-08-25 01:12:13 Re: Incorrect 'literal' tags
Previous Message Peter Eisentraut 2016-08-24 15:12:36 Re: Docbook 5.x