Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gPz6e-0002xY-Mw for pgsql-docs@arkaria.postgresql.org; Fri, 23 Nov 2018 00:14:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gPz6d-00031y-Bx for pgsql-docs@arkaria.postgresql.org; Fri, 23 Nov 2018 00:13:59 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gPz6b-00031j-OA for pgsql-docs@lists.postgresql.org; Fri, 23 Nov 2018 00:13:59 +0000 Received: from [64.147.123.25] (helo=wout2-smtp.messagingengine.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gPz6X-0007SX-1m for pgsql-docs@lists.postgresql.org; Fri, 23 Nov 2018 00:13:56 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id AAB19D09; Thu, 22 Nov 2018 19:13:31 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Thu, 22 Nov 2018 19:13:31 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=9VyhCyzbM8F+Gg/HhmxO5ely8RE VnZigbkYy18aREGE=; b=Z0T1rCL2nLuLylUBvACj8sbo8Sr83eZ/fUnYpOP5ukh C0EqrJK3adIDF5k5vC6Frl6vnKv1RPromtuxJMGETomqZqREqa4K4OBA30CdWkER LpztOTKbUXv05gFAY0m6/sTeZQmRe6WXznSt0Q93Y5/f8E1/IHX6NOHj9tAwTf89 mr6ZTB0z8gBH4uOsrsuyO9OFaJKiwAwjK4YVQzjIMEhdSb1oiNH/BzxUtAdy0Mx9 89sn06Lsm74TtHbYlkuSGLFyT5NEFH9gY5JvYXA6Q+tKMNdyYeu5+yUmz8r/aMXn Lb4x4a7XNIbyM3Gobyk1Yo+xxByHITQMezfzQqCbKAA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=9VyhCy zbM8F+Gg/HhmxO5ely8REVnZigbkYy18aREGE=; b=eVp/neAPIpw4CaHw1xk+oO UDDZltPMxm+/qSfJwOmWvfImK0J97UyHl0WP3xGDFUlNZ71aUZFT4p2ov/BQWqC1 m9skoOsxhoKqqF1491vQvbIbyIZUBYUOOVPgTuHEEKuRvf3dvqng3b93FHsVdKza aWI6N8Ned8WqJtRlAXHcOLGt9AQEXtWxmD9FeGDfPzl122Lwz9JKb1ne7q0y2kqQ cm+sdOMx9xh3GXH7y0KIXPSo3MFvUh3nH/bc1xl0mP/uNfH5eL8tNj7j7WChTtn9 Kbvrk71EffKWowYsdi6+hiowdADMEJV0uZbWyp8cYMEoa2ih4UN4UM3My3/8Rjgw == X-ME-Sender: X-ME-Proxy: Received: from paquier.xyz (c137162.net61215.cablenet.ne.jp [61.215.137.162]) by mail.messagingengine.com (Postfix) with ESMTPA id 2E893102DD; Thu, 22 Nov 2018 19:13:28 -0500 (EST) Date: Fri, 23 Nov 2018 09:13:26 +0900 From: Michael Paquier To: "David G. Johnston" Cc: "steven.winfield@cantabcapital.com" , "pgsql-docs@lists.postgresql.org" Subject: Re: CREATE/ALTER ROLE with NULL password Message-ID: <20181123001326.GA16253@paquier.xyz> References: <154282901979.1316.7418475422120496802@wrigleys.postgresql.org> <20181122020759.GE3369@paquier.xyz> <20181122075806.GK3369@paquier.xyz> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="C7zPtVaVf+AK4Oqc" Content-Disposition: inline In-Reply-To: X-Host-Lookup-Failed: Reverse DNS lookup failed for 64.147.123.25 (deferred) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --C7zPtVaVf+AK4Oqc Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thu, Nov 22, 2018 at 09:54:07AM -0700, David G. Johnston wrote: > On Thursday, November 22, 2018, Michael Paquier wrote: >> 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. > > Yes, the syntax block is perfectly clear but we still explain said grammer > in words and should be precise there as well, IMO. Not a big deal though. Okay, thanks. I have committed the simplest version. -- Michael --C7zPtVaVf+AK4Oqc Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlv3RiYACgkQnvQgOdby QH01Vw//fmC6oYXZxzbwy71EvfoIgbBi1edLCJRLPloHJKAr5CHF4oQRq5PeMiwo gtOWdC2FDCD6TfGci/dT6j7PgWfn09jhSkeNoFASCElL63KKNkM6mf49qyWKimJc gOAAPmTIq9lalAHIkEzVYSShBDAogyEjet8djiL/FT9bxJp/B7cKVQQQ0Eu1Yli2 hglJmIKPUD66hT7eFa/8cL8UtlgedBqvx0b1N78E8Yd0hcWXsFMUj0qyBGeC5tbG P9rb05HDqLq6lyA0Q37YlWQ8aqW2pFlfExwJPw7014K5xJfU1FMwsBJIz5ERrUtI BBvRrmTGHfbAP7w8xeqDUJysSvEQcQVf0gJwN58VURIdYX6g5jtmnIt6srp0GIt2 q0nNHsMArUXss7mYpLPjwYp/gh2CKNN83NeXyeGaDuJPgOa99tNatBQUtYyULjhB 3b2xjPZmdcir2eq+C52p+3BuvYir6khDplRiDi0Pify8JQEIUkpQHhd2s2lV1RHF ZzrAdkPaI++lQrLBtpxMYoYs00g6/qtQvmSdCEU9/iX8WCv3yjl6rS6LiRX0wDQx GQG5NNRQXGf5v6ZtAk8jHTVuIFk5SvDMsbkH5Cvjbl1ni7/if8wq2QpxKtzXQgxT BuHivxWr0WE6uvZ9RM5RhYRBqPStaWeLL8NkrKLpBaz2q87Uy6A= =Uoub -----END PGP SIGNATURE----- --C7zPtVaVf+AK4Oqc--