Re: CREATE/ALTER ROLE with NULL password

2018-11-21 Thread Michael Paquier
On Wed, Nov 21, 2018 at 11:58:25PM -0700, David G. Johnston wrote: > Should tweak the paragraph to point out this exception as well. > > The ENCRYPTED keyword has no effect, but is accepted for backwards > compatibility[, except in the PASSWORD NULL form.] The docs list the following with the pa

Re: CREATE/ALTER ROLE with NULL password

2018-11-21 Thread David G. Johnston
On Wednesday, November 21, 2018, Michael Paquier wrote: > Yes, that the set of grammar combination supported, as ENCRYPTED > PASSWORD NULL is not possible. > > Any objections with > the attached set of fixes from anybody? > Should tweak the paragraph to point out this exception as well. The EN

Re: CREATE/ALTER ROLE with NULL password

2018-11-21 Thread Michael Paquier
On Wed, Nov 21, 2018 at 07:36:59PM +, PG Doc comments form wrote: > The current synopsis for CREATE / ALTER ROLE give one of the allowed options > as: > [ ENCRYPTED ] PASSWORD 'password' > and the current documentation for CREATE ROLE says: > "The ENCRYPTED keyword has no effect, but is accepte

Re: Phrasing to consider (non-technical)

2018-11-21 Thread Bruce Momjian
On Wed, Nov 21, 2018 at 04:56:40PM -0500, Bruce Momjian wrote: > On Mon, Oct 29, 2018 at 02:50:22PM +, PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > > > Page: https://www.postgresql.org/docs/11/static/datatype-datetime.html > > Descript

Re: Phrasing to consider (non-technical)

2018-11-21 Thread Bruce Momjian
On Mon, Oct 29, 2018 at 02:50:22PM +, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/11/static/datatype-datetime.html > Description: > > On the page for Data Types - DateTime, there is this part of a

CREATE/ALTER ROLE with NULL password

2018-11-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/sql-alterrole.html Description: When creating a role with no password, or altering a role to remove its password, the ENCRYPTED clause must not be present. The current synopsis for CREATE