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 1tvL5Q-003f7q-J0 for pgsql-general@arkaria.postgresql.org; Thu, 20 Mar 2025 18:57:48 +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 1tvL5P-006zbK-Bf for pgsql-general@arkaria.postgresql.org; Thu, 20 Mar 2025 18:57:47 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tvL1z-006qGc-FN for pgsql-general@lists.postgresql.org; Thu, 20 Mar 2025 18:54:15 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tvL1x-000Bp8-0F for pgsql-general@postgresql.org; Thu, 20 Mar 2025 18:54: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 52KIs4CC1092934; Thu, 20 Mar 2025 14:54:04 -0400 From: Tom Lane To: =?utf-8?Q?=C3=81lvaro?= Herrera cc: "David G. Johnston" , Sebastien Flaesch , Adrian Klaver , M Tarkeshwar Rao , "pgsql-general@postgresql.org" Subject: Re: After upgrading libpq, the same function(PQftype) call returns a different OID In-reply-to: <202503201748.wxkazqupyvuk@alvherre.pgsql> References: <202503201748.wxkazqupyvuk@alvherre.pgsql> Comments: In-reply-to =?utf-8?Q?=C3=81lvaro?= Herrera message dated "Thu, 20 Mar 2025 18:48:27 +0100" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <1092932.1742496844.1@sss.pgh.pa.us> Date: Thu, 20 Mar 2025 14:54:04 -0400 Message-ID: <1092933.1742496844@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk =?utf-8?Q?=C3=81lvaro?= Herrera writes: > That said, we could add a comment that makes this more obvious: > ... > This looks a tad redundant in pg_type.h itself, but makes the generated > pg_type_d.h file more obvious: I think it's a mistake to suppose that pg_type_d.h is the only place where there's a risk of confusion. We should be thinking about this more generally: genbki.pl is taking zero thought to make what it emits readable. I think it would help to label the sections it emits, perhaps along the lines of /* Auto-generated OID macros */ for this part, and I'm not sure what other parts would be useful to label. As for CASHOID and LSNOID, surely those have been deprecated long enough that we could just remove them? regards, tom lane