Postgres Pro
Downloads
Home   >   mailing lists

Re: CREATE/ALTER ROLE with NULL password - Mailing list pgsql-docs

From Michael Paquier
Subject Re: CREATE/ALTER ROLE with NULL password
Date
Msg-id 20181122075806.GK3369@paquier.xyz
Whole thread Raw
In response to Re: CREATE/ALTER ROLE with NULL password  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: CREATE/ALTER ROLE with NULL password
List pgsql-docs
Tree view 
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 patch as supported grammar:
[ ENCRYPTED ] PASSWORD 'password' | PASSWORD NULL
And it seems to me that '|' has priority over '[]', so ENCRYPTED does
not apply to PASSWORD NULL if phrased this way.
--
Michael
Attachment

pgsql-docs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: CREATE/ALTER ROLE with NULL password
Next
From: "David G. Johnston"
Date:
Subject: Re: CREATE/ALTER ROLE with NULL password