Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qsn0Q-009QSG-4y for pgsql-hackers@arkaria.postgresql.org; Tue, 17 Oct 2023 16:33:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qsn0O-00C8uV-5R for pgsql-hackers@arkaria.postgresql.org; Tue, 17 Oct 2023 16:33:16 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qsn0N-00C8ti-SX for pgsql-hackers@lists.postgresql.org; Tue, 17 Oct 2023 16:33:16 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qsn0M-000woQ-3g for pgsql-hackers@lists.postgresql.org; Tue, 17 Oct 2023 16:33:15 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 39HGX90g2819251; Tue, 17 Oct 2023 12:33:09 -0400 From: Tom Lane To: Laurenz Albe cc: "David G. Johnston" , Erik Wienhold , PostgreSQL Hackers Subject: Re: Fix output of zero privileges in psql In-reply-to: References: <1966228777.127452.1694979110595@office.mailbox.org> <84f7a1dd3052544974d5b4d5df7beb5a244b48fa.camel@cybertec.at> <4tgcecleqgkynyat7t3innrsdpopeiukumb7s4f2gdw3zuzidb@27urnfsqebdy> <30ef7918c8f1a0b811d11350e7f658a3c3439441.camel@cybertec.at> <5uytof65cguide4mjhxzakd5w74hpuppjsrqfwuywtcf2r2xwl@lbi4fc374nig> <28a1d403ad2499865a5da1be9dc719b1218f8a8f.camel@cybertec.at> Comments: In-reply-to Laurenz Albe message dated "Tue, 17 Oct 2023 15:05:56 +0200" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <2819249.1697560389.1@sss.pgh.pa.us> Date: Tue, 17 Oct 2023 12:33:09 -0400 Message-ID: <2819250.1697560389@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Laurenz Albe writes: > On Mon, 2023-10-16 at 19:05 -0700, David G. Johnston wrote: >> Reading both threads I'm not seeing any specific rejection of the >> solution that we simply represent empty privileges as "(none)". > Thanks for that summary. I prefer my version (simply display NULLs > as NULLs), but I am not wedded to it. I had the impression that Tom > would prefer that too, but is woried if the incompatibility introduced > would outweigh the small benefit (of either patch). > So it is clear that we don't have a consensus. FWIW, my druthers are to make the describe.c queries honor \pset null (not only for privileges, but anywhere else they fail to) and do nothing beyond that. I think that'll generally reduce the surprise factor, while anything else we might opt to do will increase it. If that fails to garner a consensus, my second choice would be to do that plus translate empty-but-not-null ACLs to "(none)". regards, tom lane