Date: Thu, 22 Nov 2018 16:58:06 +0900
From: Michael Paquier <michael@paquier.xyz>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: "steven.winfield@cantabcapital.com" <steven.winfield@cantabcapital.com>,
	"pgsql-docs@lists.postgresql.org" <pgsql-docs@lists.postgresql.org>
Subject: Re: CREATE/ALTER ROLE with NULL password
Message-ID: <20181122075806.GK3369@paquier.xyz>
References: <154282901979.1316.7418475422120496802@wrigleys.postgresql.org>
 <20181122020759.GE3369@paquier.xyz>
 <CAKFQuwbugMRHCTDiZ-1G=9cHs06c6pv_dS44x4GLQ=2q5ZV2yw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="FnOKg9Ah4tDwTfQS"
Content-Disposition: inline
In-Reply-To: 
 <CAKFQuwbugMRHCTDiZ-1G=9cHs06c6pv_dS44x4GLQ=2q5ZV2yw@mail.gmail.com>
Precedence: bulk


--FnOKg9Ah4tDwTfQS
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

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.
>=20
>  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

--FnOKg9Ah4tDwTfQS
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlv2YY4ACgkQnvQgOdby
QH0aQg//V/lDuJehtwQZgIPKoPeeUvFHthcAuUMrSdN5IIniW7eGd6K2YHzOtMaH
X1gTfKvArjQdeXmK3LtFIkOwTwOb/ttOgyVCIYRMYeoV7kvOb/5czOFWVCrYY0/+
vXuSvPtwzjtVwg9Ihu57354vOg4JMzmco3zXY7jE47hLloyDGJd8vXqhfNXKqIFW
ud9b18uk1Vm4+r/WNlC8MEXlf0u4kX+AKe2suVvtyVSJC5ZerlVTrP3Q9b3mby8Q
rSUOtPV0a5OlSOcCW9zHmJFUrVC0zxihxOyp9MtskceqLiGB51UVY0h6CigJB4yn
8m6OCajI0ksqJryFxk9ByZTGVbiO7/TJCtrZEx7DCfKQrnEGxB3tZWFsjRB8FkkW
v3B0hZfegokqc/vSft92I92ZRlStJqhMLJbhcc5Nxd30tVW0e/RzRUkjDo+EMnz0
D/qGbsbwFAMB7DtG3nQDm6AvS0csVgvqx5uMZfSIyuyqjxyt1M8RuI9i3N4ktZnQ
V0og7tcT3gY7T+9XlwrZxlr6KHfmUwd0IlhuG1KqqIGGrsVxfpG7sBjjrW6YN/I/
zWidscr0VeNEGb7VEtvbCpB/+wJkqmTH3AQJvOvg9PuQ0ivLBJL9H65Jw/iHKyAm
DlnO51WEbiPPGE5Om4fRTKpN70O1G/XrEKBtQ4Gk9I4k4cmTLuQ=
=yMa4
-----END PGP SIGNATURE-----

--FnOKg9Ah4tDwTfQS--