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 1tvI2o-0038vH-CU for pgsql-general@arkaria.postgresql.org; Thu, 20 Mar 2025 15:42:54 +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 1tvI2n-003YSM-3n for pgsql-general@arkaria.postgresql.org; Thu, 20 Mar 2025 15:42:53 +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 1tvI2m-003YO3-K0 for pgsql-general@lists.postgresql.org; Thu, 20 Mar 2025 15:42:52 +0000 Received: from mx0c-001a4c01.pphosted.com ([67.231.158.153]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tvI2j-0009wh-0C for pgsql-general@postgresql.org; Thu, 20 Mar 2025 15:42:51 +0000 Received: from pps.filterd (m0210019.ppops.net [127.0.0.1]) by mx0c-001a4c01.pphosted.com (8.18.1.2/8.18.1.2) with ESMTP id 52KE5w45018514; Thu, 20 Mar 2025 11:42:42 -0400 Received: from eur05-db8-obe.outbound.protection.outlook.com (mail-db8eur05lp2110.outbound.protection.outlook.com [104.47.17.110]) by mx0c-001a4c01.pphosted.com (PPS) with ESMTPS id 45d5gp69wa-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Thu, 20 Mar 2025 11:42:42 -0400 (EDT) ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=xeqhfpiLVibQVdhhC3eqeGop8Ry/5E6vPSWBqJHag8wf8xiGhZWIvbuEgXNHahx9PD/S1qNliEytSAiPNqQStlgyWv36HDjiiw+ZbvZ4I72Xi7bS+30lcBXWRDWx7L+umLpy0e1IwJ9deWqu70OOTPms60FzXebh8NkrheIw8DcJaTgd1KRQ3b7IRh+3PJicyyBv+IZ9fIi3w9HCHrzpwevX5fpxR4vlQ82zfHzzCfxItYdJo6w8sHGCEr8s1YINP12Kl6BZ+n732Cxg5CEn5GX29BhTLkNPpOKolVLcdPA0lxik42DHwY6rTESj+TXOWOYut0XSmCt2ZOtJvM1Bug== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=tIT7jlJmxBckNOJA8vpmyahyN5UxJ1PI4EM9vSuSo5U=; b=qUMJubtH61dcTsDrHn/tbetxMoGkOhNz31q/SvQlukvKNAGqGbc5HvpAhGpECOJTPpxBnrutgOBWfYl2Yb1p/jfdI8tDrqIKBU+6cjgigqsUuo5ALJRNmatkBd0yEHShFAkEoFqOT/0nZ3QYAsZ3tLcGYJ5Ysuz0uVALlCIxZ723eO8666kjn0SAlAJBUduVNQeMh7Spg46X83Qzw/H7G+fZNz39hbNYLI8lXhIsemIO1BG14Fd00Dfl2sZlbgAO2ONLYyZTtST6QPWJVqGg7CpZ8iT7pP/ZYuOcWAd2rc1TsVhGWWZGeSiWNK2fMPuEd8OYIvIvK+9Jh2UOMDX32w== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=4js.com; dmarc=pass action=none header.from=4js.com; dkim=pass header.d=4js.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ourvolaris.onmicrosoft.com; s=selector2-ourvolaris-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=tIT7jlJmxBckNOJA8vpmyahyN5UxJ1PI4EM9vSuSo5U=; b=ODV8LiF/Y85ptJK9Nh7c9Rezjk44z2h+eQXmZ5QcmX4rZ80nwlMe/IKu5oleMmgjMRJfDx71qRgI33qvJryESiGR+8gL9VTBXDtO7oDRBuN/wGkg8xGkPaMPjd55d3NKWfOytAUUNdrx+/wq1pIXHyfRKxVZbofOkTZ/BJsRLBY= Received: from DBAP191MB1289.EURP191.PROD.OUTLOOK.COM (2603:10a6:10:1c9::19) by AS1P191MB2054.EURP191.PROD.OUTLOOK.COM (2603:10a6:20b:4a8::8) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8534.34; Thu, 20 Mar 2025 15:42:39 +0000 Received: from DBAP191MB1289.EURP191.PROD.OUTLOOK.COM ([fe80::9a60:21a1:9aa2:cdb0]) by DBAP191MB1289.EURP191.PROD.OUTLOOK.COM ([fe80::9a60:21a1:9aa2:cdb0%4]) with mapi id 15.20.8534.031; Thu, 20 Mar 2025 15:42:39 +0000 From: Sebastien Flaesch To: Tom Lane CC: Adrian Klaver , M Tarkeshwar Rao , "pgsql-general@postgresql.org" Subject: Re: After upgrading libpq, the same function(PQftype) call returns a different OID Thread-Topic: After upgrading libpq, the same function(PQftype) call returns a different OID Thread-Index: AduV23zLkRPb77LLTluClfIN9ptbAwAAUL0AAB4WV3IAeBJWgAAZCpZeABV5O4AAAQWqgAAcjkQeAA/CSYAAAhSfFw== Date: Thu, 20 Mar 2025 15:42:39 +0000 Message-ID: References: <3498256.1742065328@sss.pgh.pa.us> <295e06b4-ff5d-4d82-ba56-1bab24be6bbc@aklaver.com> <7a07f957-bb8c-413b-806a-504a5cd12072@aklaver.com> <718368.1742404967@sss.pgh.pa.us> <983724.1742481099@sss.pgh.pa.us> In-Reply-To: <983724.1742481099@sss.pgh.pa.us> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: x-ms-publictraffictype: Email x-ms-traffictypediagnostic: DBAP191MB1289:EE_|AS1P191MB2054:EE_ x-ms-office365-filtering-correlation-id: 551e1bf6-596e-4191-ec0a-08dd67c5d8a4 x-volarisppoutbound: true x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|366016|1800799024|376014|7053199007|38070700018|8096899003; x-microsoft-antispam-message-info: =?us-ascii?Q?zKQQzfQvqFLUkpCKyi+ABTbdz2hc2kUIE+I3O/1xUYq3sayWG9O33ONDRFe7?= =?us-ascii?Q?BqP0w+xUgiIcKGJVDZdHsGdBphKoplKAfcUVX+rPLzqKMvziEQ+ksTE0/fiV?= =?us-ascii?Q?nYQE/OCi9pp8MFViGUEJt7CjK6HbufYaQeTgvoKPi/Pr6WrYnw2KWmrQ1uY7?= =?us-ascii?Q?35cX8l5sGxm1TrFPLISF1pnTjxqn0beXbsXkVzyAjbg7AIGowbs3K6E14EWz?= =?us-ascii?Q?4/fSspZpi9UuJX540OSTSmN4kQjeAPIgNpc3mK+t4saWidHvl5ZO/1gQoLdQ?= =?us-ascii?Q?opR7cbpLUGax0wlV09RdmeKzldSK6d29Z7LD659M47yMAKU/Hd1dFeSpDGeO?= =?us-ascii?Q?TBDhCVtXrpxnHjns2X87PV8QZ0ZZjk1MIunt2jun4AOb0DJlARyF5YUJLxNc?= =?us-ascii?Q?nJCVHmMKAY7KCoCbPJIMu/RoailWkYK3s8sC8OagT6Is0VK1CJBp1TqxTKk9?= =?us-ascii?Q?/lRniXKg6jpZxvQTYM5CZTgXS5qV7LLlunM875+DbIeVwf4rCQ0OJ8R3qfbI?= =?us-ascii?Q?T8yNrHuZRiOG7Abk5qwLzs/xPPJwAd8z+d2WLbgUdIjdwbqxQVj8ll5LtmTP?= =?us-ascii?Q?q2Kt2RlS4bZ7MjWXQ/hU3j4WujfLKBmU/MmOTDZ1ujlyFF+PehAVGXfa8/as?= =?us-ascii?Q?HqWbB9niQoIUbEu8mRY3MPjAEmaphShLxiAfOIWq9r3XSud7aPbK6OrjTwwo?= =?us-ascii?Q?IWmUI3kNKf2V8XYNw2VZeW4JkteHYt9ISaaZd6/I76nr29OK21n5G77BODAQ?= =?us-ascii?Q?d43lpDiIgtCrPU7lZD715Wj/SBkP5tYViUkurd6EJ7aHSDR/mTaAFtKKHel6?= =?us-ascii?Q?+UNSc8dfe0OXAi7o94kW+AiflgXg9+Y7sJ5nr+SXbj1He2+W7s6LcLdONgp4?= =?us-ascii?Q?asvvzJkzmEAwLku2Mgp2DEdAO8dP+iR00wnc71ajzK2wRKRtefCG9A9JPr/W?= =?us-ascii?Q?2rpyimT9zauZF0kH13uOV49l7TqpcFCYc1oS69gcPDKPwHe2SyLLGY7OTmDF?= =?us-ascii?Q?24y2TEsKhxZiVmCK/zh2pj3PvoclRyG+ayMiC+F0H4Q4l6Aug8SF/kbr04hn?= =?us-ascii?Q?DpHIatEGw4AH2hTWcbFwVvE3y/eRvF8vl4iaVYPDSNqk0CbBAgNwH3MxPQ2m?= =?us-ascii?Q?/1fD60PQgsQpqAaOWnaWZC4+SvZkjn3w+ReIFzEYjYu8oQLt8IBcCZ0g24A0?= =?us-ascii?Q?UML2VDN1/yni3qc5806Sw5R6Ouwc0pkjsFtQ+QZh+Ywvl/H6T8GyNpQ7mgxs?= =?us-ascii?Q?ElpGKiB5n8+oQIAMI9r5KeIMAJhs7j6eLqr5Wl5hGchT686mFtFeMjY0aOvb?= =?us-ascii?Q?IroTn7g5oY78DTfUarFytZ+83Ya7aEwKa93jUxWDUlp9geAOMICI9uly2gOe?= =?us-ascii?Q?MtCMP09xNnQDWAQ0bUVdA50YKqGT6oNYaZDTAWLLXFBvEd+UUMQ2THJGjFCr?= =?us-ascii?Q?zWCMnC1KwNcvnfKsAA8bL2LnQeUCfPiy?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:DBAP191MB1289.EURP191.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230040)(366016)(1800799024)(376014)(7053199007)(38070700018)(8096899003);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?4jEKx9NVltLyWGAQf02GxdtVoDgqSHYjGGyBbGrqrzsdWLjnEHGqmauV1H4e?= =?us-ascii?Q?NNpjIS1M0s1glZtW3OK/KC0jdojgi+cG/3H8DE9vg40nhn2SeAvq5lqRBCeF?= =?us-ascii?Q?mYRKL8yxS2iYW6Xsh3/BEt1YIjN1OMUZMEURPf991ElzRFWePepPYVQdiQ0u?= =?us-ascii?Q?DnIH51L0nUjNb/mshSzcLzKEUWiTARyzUX0MBJPZGdmuZ7NT5V8iSoB61QpK?= =?us-ascii?Q?s0RnchyvN+9Ok8N9F5/6W1EJcHKLHexJVPjNpGnjCKMrW378RmwpGv6zuACW?= =?us-ascii?Q?W9uFM0e9FuTS1eYJrrIhm4bcwrP1rov/Bb6BNp+c9B49qNqgI4e1KmR5GXIq?= =?us-ascii?Q?mBWdiDUaGIFpmaltqO9KFPVByvAMN4AceJs1CSZjBURqjaGW+ZhqRrWt8PKD?= =?us-ascii?Q?FyF2Xy5JBsw7CmiuPFC5dF6ZEX+CD3xxtbxQKfDQSWJjAupRqpH5oT3qFp7d?= =?us-ascii?Q?8hCR0WjDpjJrMTg6TCG0spZA8hbbxS4ETENxzCQXxyDZXYbcw8VZDOQiaea8?= =?us-ascii?Q?c+m/vKWu3jI51Nv/IvihZzjpIOqjiOGVX+d40ASsA5kUolPqLPfJfXMhM9e2?= =?us-ascii?Q?1W5ggo1qGiHucI81UnoxOQKvf/O/ge5tKecnzYyOLNvhZyWkukiEunuCiL6u?= =?us-ascii?Q?496QSkEQL5t+geDF7drAlP53HpvUiGRfSpv0ORAbu8f4T443js8++piNxSN/?= =?us-ascii?Q?aa2PPKih5DkRmqYAsjN2r0Bm4zvcz0WzC6zIIPhXIpdvJChMv8WrA5WtcaMG?= =?us-ascii?Q?3HG8VwLioQCPFt8mu9i6MkM9bRET415IN/t9X+eMGvcgWT8kmnkL2sQNNsG1?= =?us-ascii?Q?kcS8bE33+AetnmubobkV7WmLg7RQso+qdIxP2Pc03qG22wEN06MZyDM00rHw?= =?us-ascii?Q?W2e4C6kL4e0Psvwu5T9MXJFgf5oYxztryNIda6XPOq7eT94ng8LoxUlXG+ec?= =?us-ascii?Q?ZTfVBURpCqbzIDkoqP1NsglNghRnrAdOJj03ILzZz6M1e/ya+b911FXvUZlb?= =?us-ascii?Q?CmsDHgkWRTpcq19TNOLq79pKFVptviHhHTa3spgLLNUdNyV5gf2lQOWzdHEY?= =?us-ascii?Q?m33Xo7sj2CV/48F8W8YoMYVdv8ZcjnBpxo5JyJWxKZCAwCXlmiD2tSA23xQ/?= =?us-ascii?Q?Ot5ZvD1Ps/NQTu7OxIkt6cBJ+NDNt1ZgsxgEBHnwO2Na7l4vXzmj8LKq9dgd?= =?us-ascii?Q?7lMT0Whboy/UVGH3TktcEFtndK3UnMIMrH+biLnfxlvfvZpoGL+Am3Yuwl0E?= =?us-ascii?Q?7ATWhJ7E4wXRQi2JOocwyC6V7GAN/enDR96/UJ7rRs6m1Dp2MbgMUHZCb8m1?= =?us-ascii?Q?QXmOlUm0LnS/hgh0/aM7te+yOiXKMLSZ9G46+ko1LVHX6caao8iKqVJoOy90?= =?us-ascii?Q?DdSFSwnNNUuK0WySt/vp8G6ckded5SIA+bgioJylFim9laOddRt+SSq8tCZO?= =?us-ascii?Q?+kTI+MS0Gvy9q8Vo05isHsyCqv5/NWrc+s3KQveJbw9qEpDyBXTvyL3y6pdO?= =?us-ascii?Q?h+nGcNobr9X1X2ISExgM3gkCB/5GNaXa36jSNZEJG5R9Y6WHtuReSm7pSzNc?= =?us-ascii?Q?ASagkxGz1erpQb2TBz4hNRuEVZG26SHkQTlJ6k0A?= Content-Type: multipart/alternative; boundary="_000_DBAP191MB12895511C8AF01672076F8E3B0D82DBAP191MB1289EURP_" MIME-Version: 1.0 X-MS-Exchange-AntiSpam-ExternalHop-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-ExternalHop-MessageData-0: VB2uvFkJ7/mxoqCT9iKNv6fRB6GP05WlJO3gzYmNnkKgm9s3gEyximVjWAEK2ty7Y5gHOY/W6zlHXy4YvBDliFC4ccVWDr7MgLHRyXyGf3ZIUaqymJCsU6s9vZ1gf9/CCjpKXuf8h8dd6D6ULLuHVGDRwO1UCMvwoNeoqL/XneVOLyQDSm2Wmprs7tssGK6LsJ5VgDN/mOj0NRBU3Rc+uo72m3CLsr063GUpD/yzzXvidMhGf6394a1VUu25zyiTmMO5HHf61op+IDjouEipIkSLwXULFy4kZOcz+zVY34mh3Xgp7YnSdPBHV8se8xkG4BJbJ4SJqLd2+JSm6d2foCk2rO2uBtF4Kvhx507mpSAKC6nDFAQAbT4dgU6d/s7tiyXx7BtCPpPzg6v5V/Ab8CARtCIhZQ1SwtyLVflNyZOZoSBn8ZyTcYnqHIuNQXjSqAOYNZwCk+y12g3X1yw3o89YcDZbtiuNHBpL17521NxgWFzfyyXaQ73m9NfBoOtQVUj0KfqxfiEhom9erBRzbNx2dGA31Uc3hCFXy/oYviXB6eJ0fWhrcqluGO9n+FEo0uwF6joXy7asNWmdSZWZR5jvVvuJe3NJys0kJhW2p+vSHL5NGMsb1hF8SQkTKsabeNE/JncSPTH6UKPmMI54Uw== X-OriginatorOrg: 4js.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: DBAP191MB1289.EURP191.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-Network-Message-Id: 551e1bf6-596e-4191-ec0a-08dd67c5d8a4 X-MS-Exchange-CrossTenant-originalarrivaltime: 20 Mar 2025 15:42:39.6879 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 75c696ec-5bfb-4892-9a0c-9187a9061cd6 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: 6hHZWtZm13Ci+43YLjoE4r8FXvXJS0g7dkmmgfePdlfAa6jiLIa1z8h6R2Lm1iVFcHT/LzhU8wro2BTmcz1h80MnPVKHQiU6DnIOvQ8Knag= X-MS-Exchange-Transport-CrossTenantHeadersStamped: AS1P191MB2054 X-Proofpoint-GUID: mA6WgCPisWuaCa6xfVpO1sRK8XGgx6Au X-Authority-Analysis: v=2.4 cv=abphnQot c=1 sm=1 tr=0 ts=67dc3772 cx=c_pps a=OyWdi5cYpq7wgagEp4UfQA==:117 a=lCpzRmAYbLLaTzLvsPZ7Mbvzbb8=:19 a=wKuvFiaSGQ0qltdbU6+NXLB8nM8=:19 a=Ol13hO9ccFRV9qXi2t6ftBPywas=:19 a=xqWC_Br6kY4A:10 a=Vs1iUdzkB0EA:10 a=H5OGdu5hBBwA:10 a=udrfY5dcTTYA:10 a=YiSXs9CjAAAA:8 a=SNL7wKpgAAAA:8 a=0FD05c-RAAAA:8 a=epTmVMiNAAAA:8 a=MWkNQP7Y2sHaHhFu8zwA:9 a=CjuIK1q_8ugA:10 a=x6bR53Zc4_I6SNRxjyYA:9 a=PkXsnuMrGLJiTWqm:21 a=frz4AuCg-hUA:10 a=_W_S_7VecoQA:10 a=i3Kcs0zRCnBKJ3xysGeB:22 a=uEXi9pYaZPHPrIM342IW:22 a=l1rpMCqCXRGZwUSuRcM3:22 X-Proofpoint-ORIG-GUID: mA6WgCPisWuaCa6xfVpO1sRK8XGgx6Au X-ProofpointHeader: Yes X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0 malwarescore=0 bulkscore=0 mlxscore=0 lowpriorityscore=0 phishscore=0 mlxlogscore=743 adultscore=0 clxscore=1015 impostorscore=0 spamscore=0 priorityscore=1501 suspectscore=0 classifier=spam authscore=0 authtc=n/a authcc= route=outbound adjust=0 reason=mlx scancount=1 engine=8.21.0-2502280000 definitions=main-2503200098 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_DBAP191MB12895511C8AF01672076F8E3B0D82DBAP191MB1289EURP_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Tom, They are. You were already pointed to it. The fact that you don't like how that file's name is spelled is not really going to impress anyone. I don't care about the .h file name or location, what scares me is this: /* * Backwards compatibility for ancient random spellings of pg_type OID macr= os. * Don't use these names in new code. */ #define CASHOID MONEYOID #define LSNOID PG_LSNOID #define BOOLOID 16 #define BYTEAOID 17 #define CHAROID 18 #define NAMEOID 19 #define INT8OID 20 #define INT2OID 21 #define INT2VECTOROID 22 #define INT4OID 23 #define REGPROCOID 24 If I am missing something, then please point me to the correct .h file that= contains #define constants without this scary comment. OR.... ( I guess I start to understand the code... ) it this comment only f= or: #define CASHOID MONEYOID #define LSNOID PG_LSNOID ??? And sorry if I consider constant names like these (without any prefix such = as PG_TYPE_) #define BOOLOID 16 #define BYTEAOID 17 #define CHAROID 18 #define NAMEOID 19 #define INT8OID 20 #define INT2OID 21 ... ... are looking more like names not to be used! Arrogance does not help here, clarity and better API doc would. Seb ________________________________ From: Tom Lane Sent: Thursday, March 20, 2025 3:31 PM To: Sebastien Flaesch Cc: Adrian Klaver ; M Tarkeshwar Rao ; pgsql-general@postgresql.org Subject: Re: After upgrading libpq, the same function(PQftype) call returns= a different OID EXTERNAL: Do not click links or open attachments if you do not recognize th= e sender. Sebastien Flaesch writes: > Native PostgreSQL built-in SQL types should be listed in a .h header of t= he C client API They are. You were already pointed to it. The fact that you don't like how that file's name is spelled is not really going to impress anyone. regards, tom lane --_000_DBAP191MB12895511C8AF01672076F8E3B0D82DBAP191MB1289EURP_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
Tom,
They are.  You were already pointed to it. The fact that you don't
like how that file's name is spelled is not really going to
impress anyone.
I don't care about the .h file name or location, what scares me is this:

/*
 * Backwards compatibility for ancient random spellings of pg_type = OID macros.
 * Don't use these names in new code.
 */
#define CASHOID MONEYOID
#define LSNOID  PG_LSNOID

#define BOOLOID 16
#define BYTEAOID 17
#define CHAROID 18
#define NAMEOID 19
#define INT8OID 20
#define INT2OID 21
#define INT2VECTOROID 22
#define INT4OID 23
#define REGPROCOID 24

If I am missing something, then please point me to the correct .h file that= contains #define constants without this scary comment.

OR.... ( I guess I start to understand the code... ) it this comment only f= or:

#define CASHOID MONEYOID
#define LSNOID  PG_LSNOID

???

And sorry if I consider constant names like these (without any prefix such = as PG_TYPE_)

#define BOOLOID 16
#define BYTEAOID 17
#define CHAROID 18
#define NAMEOID 19
#define INT8OID 20
#define INT2OID 21
...

... are looking more like names not to be used!

Arrogance does not help here, clarity and better API doc would.

Seb
From: Tom Lane <tgl@sss.= pgh.pa.us>
Sent: Thursday, March 20, 2025 3:31 PM
To: Sebastien Flaesch <sebastien.flaesch@4js.com>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>; M Tarkeshwar Ra= o <m.tarkeshwar.rao@ericsson.com>; pgsql-general@postgresql.org <p= gsql-general@postgresql.org>
Subject: Re: After upgrading libpq, the same function(PQftype) call = returns a different OID
 
EXTERNAL: Do not click links or open attachments i= f you do not recognize the sender.

Sebastien Flaesch <sebastien.flaesch@4js.com> writes:
> Native PostgreSQL built-in SQL types should be listed in a .h header o= f the C client API

They are.  You were already pointed to it. The fact that you don't
like how that file's name is spelled is not really going to
impress anyone.

            &nb= sp;           regards, to= m lane
--_000_DBAP191MB12895511C8AF01672076F8E3B0D82DBAP191MB1289EURP_--