Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p0Oar-00014i-AN for pgsql-hackers@arkaria.postgresql.org; Wed, 30 Nov 2022 15:01:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p0Oap-0002RB-1w for pgsql-hackers@arkaria.postgresql.org; Wed, 30 Nov 2022 15:01:47 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p0Oao-0002R1-Hi for pgsql-hackers@lists.postgresql.org; Wed, 30 Nov 2022 15:01:46 +0000 Received: from mail-qv1-xf30.google.com ([2607:f8b0:4864:20::f30]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p0Oaj-0000jt-IL for pgsql-hackers@postgresql.org; Wed, 30 Nov 2022 15:01:45 +0000 Received: by mail-qv1-xf30.google.com with SMTP id r15so11621102qvm.6 for ; Wed, 30 Nov 2022 07:01:41 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leadboat.com; s=google; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:from:to:cc:subject:date :message-id:reply-to; bh=21Uyo3GkwlX2vbW6pR+UDMR4PNNy7tu3+lAEAbcJ7Ns=; b=VueVKlq6l6QjyG5nuIFFVU5OAp4qlHlixaM6DTYymUI58LGl16Hcv4UAQAJ0Ssp97V 8NqwABtfSxhQZpP8egy+rSB2PKhoiJ2KkGHkU0xQ5Bn2BAtXBMLDVuhbtDjFM88MkJjg 1AB0yHCPTFBK2Yi31r7LkPEa4QpvQ5mAR7/ww= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=21Uyo3GkwlX2vbW6pR+UDMR4PNNy7tu3+lAEAbcJ7Ns=; b=Xk1Rvo+SB1b0UpY0U2PIA8pzwOWVryvU7/CoyjBrTmSWTHFCtynWL7gYfn802uFCfJ rRMra5EJ5xbdX7CcoXJJsn6S4VDNdqpqRjTLv8C+n9esiJcPyeJTj9KdGQfKUKa3LjQU M7z/vYPDo2gKZnPEU7KSgTF2dlXsmtH3m17YbkeppwzZY9YaOzFA881+DBCYdvLkfD8D h9zYB+1GDi9i+vRhtxlKGBEIeDhTkzGlyBYmKwB/DFJz+w+vEBO1jEQHK6pxAVA/GN1M W/P45YDgs6IIDarvBW3ww7v8WWIF4ObdZ4+Mfj67PuH2owGPf0h3QBQfeQqXmibXhlEv b5LQ== X-Gm-Message-State: ANoB5pnQWy2MiNBDKCiu12RY02w4LScXlDE2H8bggljlYjcYq6Vkusou 0hijiY76mjKTz033ylku77DGBA== X-Google-Smtp-Source: AA0mqf7GoGknroKX6GwNWXQl57cRaEbFmMQUKINveCwvgvUifQK75PqEoXAPJt2B56v+6oYZiIPM5A== X-Received: by 2002:a05:6214:5e0d:b0:4c6:b083:3c44 with SMTP id li13-20020a0562145e0d00b004c6b0833c44mr40331253qvb.94.1669820499547; Wed, 30 Nov 2022 07:01:39 -0800 (PST) Received: from rfd.leadboat.com ([2600:1702:a20:5750::2e]) by smtp.gmail.com with ESMTPSA id dt34-20020a05620a47a200b006fbbacde9e4sm1294186qkb.78.2022.11.30.07.01.38 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Wed, 30 Nov 2022 07:01:38 -0800 (PST) Date: Wed, 30 Nov 2022 07:01:36 -0800 From: Noah Misch To: Robert Haas Cc: "pgsql-hackers@postgresql.org" Subject: Re: pgsql: Revoke PUBLIC CREATE from public schema, now owned by pg_databas Message-ID: <20221130150136.GA287291@rfd.leadboat.com> References: <20221130070701.GA275942@rfd.leadboat.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Nov 30, 2022 at 08:39:23AM -0500, Robert Haas wrote: > On Wed, Nov 30, 2022 at 2:07 AM Noah Misch wrote: > > In general, the documentation should prefer simpler decision trees. > > True, but I found the current text confusing, which is also something > to consider. Could remove the paragraph about v14. Could have that paragraph say explicitly that the REVOKE is a no-op. Would either of those be an improvement?