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 1gPiwc-0006sG-AB for pgsql-docs@arkaria.postgresql.org; Thu, 22 Nov 2018 06:58:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gPiwZ-0003KS-Pc for pgsql-docs@arkaria.postgresql.org; Thu, 22 Nov 2018 06:58:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gPiwZ-0003KL-Hb for pgsql-docs@lists.postgresql.org; Thu, 22 Nov 2018 06:58:31 +0000 Received: from mail-qk1-x731.google.com ([2607:f8b0:4864:20::731]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gPiwX-0000tE-6w for pgsql-docs@lists.postgresql.org; Thu, 22 Nov 2018 06:58:30 +0000 Received: by mail-qk1-x731.google.com with SMTP id o125so6346093qkf.3 for ; Wed, 21 Nov 2018 22:58:28 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=eTnmJp2+NAxTwHuGq73VShcELCUtsvEifVK674jh0vE=; b=rwVGxAC6ziM4UJj/N0Une6tAsoh5MkXM0sk6I2+BAN06jcJbilhDnZizUQ6rigEiqz ntfNmHSKzv3gc/JPfwRr3G605Nk8p3YRuywulpEgQSkxckKdCntMKpJNofQNKZrfqr7w uy9V8da1NLL8RPepG0U0UWGjWT27JKUunqUBgPoHTmRJpc0U5jRxt/fKG/cMs0TPK9la CYBOZJiVqjyLyXxg2+6CfjrMY82KEIMqzqYlY2seY15+ytfwyp9a1ZLpnpR5TC6rb2A9 VshMp00UuWoeJDGyI27aUzH+zcROKvreCl/FtkLxfkwRcolD+w6v+XLP9aJI2b45O3FY 3z/w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=eTnmJp2+NAxTwHuGq73VShcELCUtsvEifVK674jh0vE=; b=FfGXh3ZHeHX9nK5NzMnlHVpt/NPZ2DSlKQJlEXGacp6DvzU0GfAcrY9JYner8Sm5Ql wY9wtgbWEZJkfP41HvCxeSllcF1AF6tBYL12QMkOgEZD6HHNcJ9peXfo+LiLWMqreykh gkjm+mdQdIZunGJ5Xd5mDPJMr/aJVA0If2YRv0VQDDqk//oPaMteYcWNsNZ9F3EpBrsI DG9oe4GPRPZovV9Hx7byDPls70DHv00/eFUJ3nUpUS6Gyic2nWqb1uL/PRkr7wm/CmVP NpZ3Ou+4U0gGj2tFje3CLNpVAfuAsJIqBwBc8xGUljLfMU3BEtOYYrsduobDTWlW+fiD Xo5Q== X-Gm-Message-State: AA+aEWaqzB6YfMq4g4zwydC/8xbyTET4Brv6UEjS/uIlqOlUDGiH4Ux4 WcsVBZa98HcnchbnwxKHKtsLMzFLN8Qm3Bxlv5o= X-Google-Smtp-Source: AFSGD/UTAnobtA+p9RGVoD2O43yxYnvXNT5O+XMK2XJyBUWbo+UZLqc7LUTD1RxglKEz6pQQi1GWvgzegDgX5yx4AWA= X-Received: by 2002:a37:2ec4:: with SMTP id u187mr8600746qkh.304.1542869907095; Wed, 21 Nov 2018 22:58:27 -0800 (PST) MIME-Version: 1.0 Received: by 2002:a0c:ad5b:0:0:0:0:0 with HTTP; Wed, 21 Nov 2018 22:58:25 -0800 (PST) In-Reply-To: <20181122020759.GE3369@paquier.xyz> References: <154282901979.1316.7418475422120496802@wrigleys.postgresql.org> <20181122020759.GE3369@paquier.xyz> From: "David G. Johnston" Date: Wed, 21 Nov 2018 23:58:25 -0700 Message-ID: Subject: Re: CREATE/ALTER ROLE with NULL password To: Michael Paquier Cc: "steven.winfield@cantabcapital.com" , "pgsql-docs@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000bf4486057b3b645c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000bf4486057b3b645c Content-Type: text/plain; charset="UTF-8" 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 ENCRYPTED keyword has no effect, but is accepted for backwards compatibility[, except in the PASSWORD NULL form.] David J. --000000000000bf4486057b3b645c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, November 21, 2018, Michael Paquier <michael@paquier.xyz> 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 th= is exception as well.

=C2=A0The=C2=A0ENCRYPTED=C2=A0keywo= rd has no effect, but is accepted for backwards compatibility[, except in t= he PASSWORD NULL form.]

David J.<= /span>
--000000000000bf4486057b3b645c--