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 1qCqt7-0002DJ-Gw for pgsql-hackers@arkaria.postgresql.org; Sat, 24 Jun 2023 00:12:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qCqt5-00080c-Mm for pgsql-hackers@arkaria.postgresql.org; Sat, 24 Jun 2023 00:12:23 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qCqt5-000807-8o; Sat, 24 Jun 2023 00:12:23 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qCqsy-0005jO-Gd; Sat, 24 Jun 2023 00:12:21 +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 35O0CBfh105357; Fri, 23 Jun 2023 20:12:12 -0400 From: Tom Lane To: "David G. Johnston" cc: "Jonathan S. Katz" , Pavel Luzanov , Robert Haas , David Zhang , "pgsql-hackers@lists.postgresql.org" , rmt@lists.postgresql.org, horikyota.ntt@gmail.com Subject: Re: psql: Add role's membership options to the \du+ command In-reply-to: References: <1525117.1680628353@sss.pgh.pa.us> <1575395.1680629866@sss.pgh.pa.us> <1831161.1680703111@sss.pgh.pa.us> <2977612.1683131109@sss.pgh.pa.us> <39e7431c-1224-ab05-c67c-68f4cf625442@postgrespro.ru> <6b64c59a-fe41-bb07-d0cd-856896412b00@postgresql.org> <7aa3d663-1ea9-de0d-c13a-cbce83902214@postgrespro.ru> <2aa2bbb9-d8cb-cddf-875f-49b2634525c1@postgre! sql.org> <4128935.1687478926@sss.pgh.pa.us> Comments: In-reply-to "David G. Johnston" message dated "Fri, 23 Jun 2023 08:52:34 -0700" MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-ID: <105355.1687565531.1@sss.pgh.pa.us> Content-Transfer-Encoding: 8bit Date: Fri, 23 Jun 2023 20:12:11 -0400 Message-ID: <105356.1687565531@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk "David G. Johnston" writes: > On Thu, Jun 22, 2023 at 5:08 PM Tom Lane wrote: >> * Personally I could do without the "empty" business, but that seems >> unnecessary in the tabular format; an empty column will serve fine. > I disagree, but not strongly. > I kinda expected you to be on the side of "why are we discussing a > situation that should just be prohibited" though. I haven't formed an opinion yet on whether it should be prohibited. But even if we do that going forward, won't psql need to deal with such cases when examining old servers? regards, tom lane