pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedupdate to alter user mapping example
2+ messages / 2 participants
[nested] [flat]
* update to alter user mapping example
@ 2016-08-25 01:07 gabrielle <gorthx@gmail.com>
2016-09-20 17:12 ` Re: update to alter user mapping example Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
0 siblings, 1 reply; 2+ messages in thread
From: gabrielle @ 2016-08-25 01:07 UTC (permalink / raw)
To: 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
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
Attachments:
0001-correct-ALTER-USER-MAPPING-example.patch (text/x-patch, 969B) download
From 96ea52b63a82dd4dea24754f233978821b1e74d4 Mon Sep 17 00:00:00 2001
From: gabrielle <gorthx@gmail.com>
Date: Wed, 24 Aug 2016 18:01:03 -0700
Subject: [PATCH 1/1] correct ALTER USER MAPPING example
Existing example threw an error.
---
doc/src/sgml/ref/alter_user_mapping.sgml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/doc/src/sgml/ref/alter_user_mapping.sgml b/doc/src/sgml/ref/alter_user_mapping.sgml
index 3a90813..95f59e5 100644
--- a/doc/src/sgml/ref/alter_user_mapping.sgml
+++ b/doc/src/sgml/ref/alter_user_mapping.sgml
@@ -91,7 +91,7 @@ ALTER USER MAPPING FOR { <replaceable class="parameter">user_name</replaceable>
<para>
Change the password for user mapping <literal>bob</>, server<literal> foo</>:
<programlisting>
-ALTER USER MAPPING FOR bob SERVER foo OPTIONS (user 'bob', password 'public');
+ALTER USER MAPPING FOR bob SERVER foo OPTIONS (SET password 'public');
</programlisting></para>
</refsect1>
--
2.7.4
* Re: update to alter user mapping example
2016-08-25 01:07 update to alter user mapping example gabrielle <gorthx@gmail.com>
@ 2016-09-20 17:12 ` Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
0 siblings, 0 replies; 2+ messages in thread
From: Peter Eisentraut @ 2016-09-20 17:12 UTC (permalink / raw)
To: gabrielle <gorthx@gmail.com>; pgsql-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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2016-09-20 17:12 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-08-25 01:07 update to alter user mapping example gabrielle <gorthx@gmail.com>
2016-09-20 17:12 ` Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
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