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 1qMraT-003TLE-K5 for pgsql-general@arkaria.postgresql.org; Fri, 21 Jul 2023 14:58:33 +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 1qMraR-0036vn-H8 for pgsql-general@arkaria.postgresql.org; Fri, 21 Jul 2023 14:58:31 +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 1qMraR-0036uk-6X for pgsql-general@lists.postgresql.org; Fri, 21 Jul 2023 14:58:31 +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 1qMraK-000hcy-FP for pgsql-general@lists.postgresql.org; Fri, 21 Jul 2023 14:58:29 +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 36LEwL8j828617; Fri, 21 Jul 2023 10:58:21 -0400 From: Tom Lane To: Joseph Koshakow cc: pgsql-general@lists.postgresql.org Subject: Re: aclitem binary encoding In-reply-to: References: Comments: In-reply-to Joseph Koshakow message dated "Fri, 21 Jul 2023 10:30:09 -0400" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <828615.1689951501.1@sss.pgh.pa.us> Date: Fri, 21 Jul 2023 10:58:21 -0400 Message-ID: <828616.1689951501@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Joseph Koshakow writes: > Is this an intentional decision to not support a binary encoding for > aclitem types? Or is it just a lack of a feature? I think it's at least somewhat intentional, to have a core type that has no binary I/O so that that case can be tested. In any event, a binary representation probably wouldn't be terribly useful, as it'd contain role OIDs that wouldn't reliably transport from one system to the next, and also privilege bitmasks that we sometimes redefine. regards, tom lane