pgsql: Clarify documentation about PASSWORD in CREATE/ALTER ROLE

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Clarify documentation about PASSWORD in CREATE/ALTER ROLE
Date: 2018-11-23 00:12:58
Message-ID: E1gPz5e-0002Eq-Lf@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Clarify documentation about PASSWORD in CREATE/ALTER ROLE

The documentation of CREATE/ALTER ROLE has been missing two things
related to PASSWORD:
- The password value provided needs to be quoted, some places of the
documentation marked the field with quotes, but not others, which led to
confusion.
- PASSWORD NULL was not provided consistently, with ENCRYPTED being not
compatible with it.

Reported-by: Steven Winfield
Author: Michael Paquier
Reviewed-by: David G. Johnston
Discussion: https://postgr.es/m/154282901979.1316.7418475422120496802@wrigleys.postgresql.org

Branch
------
REL_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/3dab288f492d38d60a2cf02ba85c05df6e329ab1

Modified Files
--------------
doc/src/sgml/ref/alter_role.sgml | 5 +++--
doc/src/sgml/ref/alter_user.sgml | 2 +-
doc/src/sgml/ref/create_role.sgml | 5 +++--
doc/src/sgml/ref/create_user.sgml | 2 +-
4 files changed, 8 insertions(+), 6 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message David Rowley 2018-11-23 03:35:58 Re: pgsql: Fix tablespace handling for partitioned indexes
Previous Message Tom Lane 2018-11-22 20:14:11 pgsql: Fix another crash in json{b}_populate_recordset and json{b}_to_r