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 1tun7V-00Badk-9F for pgsql-general@arkaria.postgresql.org; Wed, 19 Mar 2025 06:41:41 +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 1tun7U-00Exs7-1t for pgsql-general@arkaria.postgresql.org; Wed, 19 Mar 2025 06:41:40 +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 1tun7T-00ExeS-Da for pgsql-general@lists.postgresql.org; Wed, 19 Mar 2025 06:41:39 +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 1tun7O-003i8i-0W for pgsql-general@postgresql.org; Wed, 19 Mar 2025 06:41:38 +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 52J41dnO011664; Wed, 19 Mar 2025 02:41:29 -0400 Received: from eur05-am6-obe.outbound.protection.outlook.com (mail-am6eur05lp2112.outbound.protection.outlook.com [104.47.18.112]) by mx0c-001a4c01.pphosted.com (PPS) with ESMTPS id 45d5gnvg7m-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Wed, 19 Mar 2025 02:41:29 -0400 (EDT) ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=q1TbrMdr4a+ZI30TZfFuwTSO5D/78EuZkLXKzVgWkiUU5aIVoR95/4mq9cb80ev9ElVTwppU3caxfQcbGKWMlvKABKysJ4tq2MwUd6GrVWqLz9onb5qJs7RKMF0Q6cmhce2Ilb5dWD6jhQ6x7KaDP05v1QiEuunUjSMWD1ioyXNiYZ6hieSL1g3TPdMgmvcmaUg0I5DuRQGX5ceklX8Af7huBeHzMYOifPVsmUfpoFOBeVu48EwMdnKSoumDBiy0eyCFzTSAS83h0t7R6h7GLs2Z6t/9woT4bqRvfZDnQNljz7PU2wvp+jIn8Fu0xMz8rDatBHHoI0Oe+KZ6nZ+EGg== 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=5Ip8zfS4rFK06L2k+s5FQlyzC9qYbEweL+c7h2gkoDQ=; b=i9ssKlrC0hJqq+7FBDwsBscDu2T2Im+PVyku01Z8AiOfHVNA09AImW7aLs4qY/Z+5Jcolrc/DM3rq072EMJ9gypK/p2tcTWutf31NmVX2NuAQp2KbFm/rbkPZC5S0dzfr/2GJ81ALnrdncLvIXgOxBTu/slfk+pxlD8rD6ENf+U904v8GEVddzXlJfQ01Dsfq4l7yK8BwSgEzbpVRHi4Iw5iUx9eQWWLYjAdpDEmDfFeqFd9O8KyN2vMlEDsNHOqS6+B9N6hjAnwNb6UygRYZSRkbkOZC/DToHgAcD/nEDDTkZOmzbnoDL78sdKeH/20DLyFNnrauN2QZj6N1pB9lg== 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=5Ip8zfS4rFK06L2k+s5FQlyzC9qYbEweL+c7h2gkoDQ=; b=cRNnNKc0Mc4t1n9TVe8nz11tQ474jNRXzgSOTfKpc0iQAoFNpBFQ009sp2COvstDZtmaoox/UjdaVpg9rfJr9wH8iUbmWAh9o7KrN+GNFlFr4Bnezp0yAvhAkRyz+BJPQvcafRECOnx3ocZXcHngWLEzTanz4jQHsq2B+JVRO1Q= Received: from DBAP191MB1289.EURP191.PROD.OUTLOOK.COM (2603:10a6:10:1c9::19) by DU0P191MB2033.EURP191.PROD.OUTLOOK.COM (2603:10a6:10:341::22) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8489.25; Wed, 19 Mar 2025 06:41:26 +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; Wed, 19 Mar 2025 06:41:25 +0000 From: Sebastien Flaesch To: Adrian Klaver , Tom Lane , M Tarkeshwar Rao CC: "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: AduV23zLkRPb77LLTluClfIN9ptbAwAAUL0AAB4WV3IAeBJWgAAZCpZe Date: Wed, 19 Mar 2025 06:41:25 +0000 Message-ID: References: <3498256.1742065328@sss.pgh.pa.us> <295e06b4-ff5d-4d82-ba56-1bab24be6bbc@aklaver.com> In-Reply-To: <295e06b4-ff5d-4d82-ba56-1bab24be6bbc@aklaver.com> 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_|DU0P191MB2033:EE_ x-ms-office365-filtering-correlation-id: f58af523-4199-4606-c68c-08dd66b1122d x-volarisppoutbound: true x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|1800799024|366016|376014|38070700018|7053199007|8096899003; x-microsoft-antispam-message-info: =?us-ascii?Q?/TIEK6dW4m5rfS6Ad8blDEeIy3Xj7IL+OvEYY70vAW8IGQftM79MiFUSyDQm?= =?us-ascii?Q?bhEdihc3w8CFBXYL+xh0V9591Txl5HNKvc1toFwQAQ6Z2o2NuPpgxlYBudFB?= =?us-ascii?Q?IYk0zFk9ylfnyOlvcozhGN3oEvI5qzSb2i7zzuRghsIsrkPpGQ2Zkf52KUOL?= =?us-ascii?Q?cSaiYA/cvyMf1CBR3Jn/moh4NMIDKBCRIGLMWEPlsUd3Pf62Gb8xCrqbjIDa?= =?us-ascii?Q?Djd54PHp8ZuqR84ZpviBmRynGbWhhRTMyOEYLxb2/UfuYZVmpgLgoW2UjKBj?= =?us-ascii?Q?xiH+usryN9YLfu3Lm9pDZM//ctqTR9YKUcN/IO86BtpC0tfUK9tr7ew/aJjc?= =?us-ascii?Q?KVZhC7mIr5JOQrYXLUjCZicBBBf1ib/Lh09AghcC09Lj++WdOegsv9W1or54?= =?us-ascii?Q?j2iPwTUwhIoOtFuk8ICJUcHaJx7Gl1c6L5eCnqPC9Dd6ijDr/SCsxRBqgMR+?= =?us-ascii?Q?pCNHQ7WFTdhT72/VGFujmNlb5HG+fBeHy88TRlyr9zV0tA4vRuJefBjD2/xi?= =?us-ascii?Q?DDJgH19BKet/U7RoftvYMfmD47iuqBBXrnSFzJRgZt4HunzzqnfEEGJNsoeL?= =?us-ascii?Q?lmHLshpWUD9DdduUoaCwJmpZ+fQ/SwzuptKZDbdPF1u1CEpHs6CmOe83bC0N?= =?us-ascii?Q?y53vRgtrlXJQwvw68RJPgflv19Bbie3yt6jIPMHZVVEtiWwQuMfz3/3TOu9b?= =?us-ascii?Q?WbCNN0LxjjOPi6FCg6WKK1oK53Ofd5o9llcKBwktrFXTTRcsImO7Qk/jmPcR?= =?us-ascii?Q?k1eYKR7PaE7k1xTCMDZ4cLOzc1Kj2QlXsUmHweLHjJoRYI7gV4iTD/EDcemS?= =?us-ascii?Q?o3VYH8FDj+/53xVy4dWWlkEZhu022SQlH1+8k3Me0voRKAQ3SQQ9gUZB1Aj4?= =?us-ascii?Q?wONiA04+RRmPChPMvaVUHi6sTXvFxNlRKWz3O6UmPDRTExz/gFnREDXvvJPv?= =?us-ascii?Q?hVyZ2qPptAzeE33fs4aCY5JV/rMc9pJnEdDUwNIF9mczxYU8h6/LUBMX2AW/?= =?us-ascii?Q?y+kSY4wx2UKFrEwi4CsfDW3b4DMJalEkbF2NMfdbZfpO85f3H6MEuZ2SVAlW?= =?us-ascii?Q?a2eh0MYu6XLI00cVCRp22obpk0cbzxr8IV73DFkb/mH7QqeAnGOWE/LebUtQ?= =?us-ascii?Q?MJcDZAy8Z8UrvVmTGUX+y3avTUTTI2wbW3jc8SdKmEsQTNMnTJKgl0xk+Tkt?= =?us-ascii?Q?7z5uwJoAApeiPf4Dju/pKPzKKdPjH3WOgE+b7dZO/wJGEb8MRDijmFnL3KoH?= =?us-ascii?Q?Jf5E5CdxLqKh42pDel9XlrkTvvE6taolmMv3/Ckes4i8P5MgHe2YiiCIhKBa?= =?us-ascii?Q?ntmjoRg3/9SiALAQSZYWYPft1qQACmgu5JyOCLyjyfvKF/P3Pd8bJHqAllko?= =?us-ascii?Q?coDHOKw+DjbQ96BJDpn9Lm775o3Az+LdfVKRfyw0twkfdPfFqzPtnpmE3kik?= =?us-ascii?Q?vF8FXyKpyPqy2UeB/SRp97VQVS0TWfuh?= 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)(1800799024)(366016)(376014)(38070700018)(7053199007)(8096899003);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?HLR9cSqcuyJeMrxM39eo8B3cEntP9Y6rSlbuM6PMFzJmkzMAtWaHM7bDKkjM?= =?us-ascii?Q?tchQpqxeIU8RLO8vRDyulFNA2EwERNAIiNkKpyhyojoCfpDgdPSrhpPAjb8M?= =?us-ascii?Q?HNiYaPc3NyYOwbFWxms/qlr7p8TR/0U4nTdpkTfLMrcIDa9PVtgqu5cFgmVV?= =?us-ascii?Q?xOl/BLQbXVztgM7161zkdi6liYoUW8Gatry23497/+Sp2DxRj4/EVL34KOv+?= =?us-ascii?Q?nM56JFdi+Bz2kWthwA7r2BtkOyr3veqez0qUerlC7Wzm7lV6z/jFLVYlNe/y?= =?us-ascii?Q?9PGn4BBn0efUfRtDbLY0ygu3Hbh5gaetFLGo2VVLW5mEXlkdBYOTVX2hsBqH?= =?us-ascii?Q?2NLzP8cDq15GKoID51S97FgaZUoSfjFW4jwAsMU5/7sLkxTwoebP0rVrVfz2?= =?us-ascii?Q?XBZly34jBecpZN9OkL9GazjU+JeowPz1OqDKo0uuVR+m/RTEa5GyAkhnNg4U?= =?us-ascii?Q?ztNVzlXfkUB5kKFdwbn7uTpZjdtDsjytByouXuSS5mnWIGS5bXEpqWpSOeoP?= =?us-ascii?Q?fqO8IZn51y03RW0oDz4bYQzPEShIgO285IihGCSa4nYWmJOcPfvwjE9HSRpN?= =?us-ascii?Q?3LTDgW4UvtOxCo3hgzn0zrFuNl+hmIrqmcxjwoR0F+h/lHoNOshgukk0MMMw?= =?us-ascii?Q?Zv3Ild67wW9sUMwoZ42RJ4tF0MO+k1TIpc1sgDNxybVmAHPI23PAPg/EvxmQ?= =?us-ascii?Q?Mi4RyZuhjyYWWKs43Z5+Ym+LISSOW0MeSzV8A61iBg7twtamrWLg3m5KoeFy?= =?us-ascii?Q?KYv0gVqu4dOrXra0fTT8c7b64AnqzjWSWU/FFpWXp7QsIks+mKwNs+MJo2MR?= =?us-ascii?Q?ESynGh4tLFW/5zSuW9G8sjGeqSXauo0hZFTyECPX8V6Ipty4nsUCPydFgvZ4?= =?us-ascii?Q?s/zLZ7VaB57WUVic5/D7iIkhuBcGHgEJ1w5dF2gXlHqWPiAs+mntf9MYPnFC?= =?us-ascii?Q?0KSB+uy66YgDKzahn9JzNGKjvW3Eyz8EsELT/unij7PEFj2cbS8vND8sOEKn?= =?us-ascii?Q?W6zLjrHII324K1GK/5Gr4BX3pg4Gx6by6COuh9mbpw/jywQH5OHmhnSZP2OD?= =?us-ascii?Q?jQ3dDxdwKbcW/F1gX6NRKoU0+NOgOZ8hrKSOkKoCy35LkF8PEIBWYoNwWKiP?= =?us-ascii?Q?0QhrVt+6cyd8xSNrwUmlfb7lOSrmWClGpDuLuy/dJLoqj0LK29Gw1TVfHvsA?= =?us-ascii?Q?wv5g2aemmKfDYE39KIm2hKsHg6uMBjqA+JYGdqtNytYmtAz6wSX6k6nar/IF?= =?us-ascii?Q?zhj263gytNqdMgtPK/DtTg5UtajotJSmPI3DQ2prmM8ziNAbp10MEC6GdF4G?= =?us-ascii?Q?eYsrZdzTKTN2ejQFvZkmXWfvR9l5Vj5Uh140rXgjLx5mj6vWv6FPZBqPNF/E?= =?us-ascii?Q?W9mwEbLP4hyjPhQpDEGPd0ECFtlu27DShBRrbYYW5yYAvAzgTMgPJTOqZOL2?= =?us-ascii?Q?8qzaQQnXIek9SZjMwfgC0eTbFv4lzNqtsNMB585hwuGyDSrcLF+tQ5dLxzJH?= =?us-ascii?Q?uTmcWvpN+eCjX6khVcR957l1eeRbtLkKYyBSfZhZjYlScCjqTvOs72B8zoQE?= =?us-ascii?Q?18EfdlAnJD91h9WSUWa60vVlAI/cj3JH667GvJmO?= Content-Type: multipart/alternative; boundary="_000_DBAP191MB1289C92E15014C2627C49BEBB0D92DBAP191MB1289EURP_" MIME-Version: 1.0 X-MS-Exchange-AntiSpam-ExternalHop-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-ExternalHop-MessageData-0: ay4w+SPjHThYunoDxPq96yh4r9CuA2JXETftjbAELr8e8AIN7EU3vi7df64bupOgHz+vjZMWXx0zddjK8FeXc9S5cCVI/X1UfZh7irqTCiCVj2CWEnhGgNk0mDTWxzkVezTtjlqJdDI75Lw1+1/w2vkN810TaECwcoGqz7/ZGjSeglLcI3B7JUuMTDWYkEeWoMAwKmNs/xM+STps2zxJE8rn+rNgT3o6alGO3UhIq+WUEPWisY0WgKrhTItzSo8P9cc6cK50wmuHvN2KLCwGDy4KJmDNHBlpQx2e9gkwtv/Aj3lzsj+KFq7NZwF4H+7Fp62efWyfBsFKHc9P05YMfcvRyFR9KqJ3rBYYaOiN5n/OuflRbGq6VRnVmfMHRRP7K1A5eojmRHiRILjKscqmVw1yg9nMivCT3wd1io5p4bjFO3nbiYwJX/F8HrRuBatY7ovur1KUJspIEMTVByenORsKcSv3HRc4BeYhZ1sOm4g8iADG/WTk0fzl8JmmVtg9qU36KNuPgjBM1CM6OsnBUhzuHQSpZRLIvH4AsePmINcNQB+hhir8UtRaqzwobqSL7n1/Es/zxXS2GXuvQVDhD4WsHLe9j+C7gc4lKl5V8IAMrsvk59+d2ptUCK4G23PV4+D1YcsVLwGt/8G8zF862A== 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: f58af523-4199-4606-c68c-08dd66b1122d X-MS-Exchange-CrossTenant-originalarrivaltime: 19 Mar 2025 06:41:25.6159 (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: w9AEk+wza77B8m18bybqsggY4LKF9kdKbjEzBN4AkS6MBGEShEfnJoKXeMIcB0Q/rpIN67wWbMM4Q6sTwxsrfSKVRhaL6QXhWyn9CLuYpfQ= X-MS-Exchange-Transport-CrossTenantHeadersStamped: DU0P191MB2033 X-Proofpoint-GUID: T3P4PylR53kCnX-whI0_cX-oMhst4mW5 X-Authority-Analysis: v=2.4 cv=abphnQot c=1 sm=1 tr=0 ts=67da6719 cx=c_pps a=D21qXYjmxBfra4Dx/gklFw==: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=epTmVMiNAAAA:8 a=SNL7wKpgAAAA:8 a=YiSXs9CjAAAA:8 a=0FD05c-RAAAA:8 a=hEuo4wOGOEmaOOqUADsA:9 a=CjuIK1q_8ugA:10 a=dy8i-Y04Ge0A:10 a=2SZzFt4ev9gA:10 a=JmNNZaDLWqHy_YfWPPQA:9 a=NAWzbRLOhQbJX7-M:21 a=frz4AuCg-hUA:10 a=_W_S_7VecoQA:10 a=uEXi9pYaZPHPrIM342IW:22 a=i3Kcs0zRCnBKJ3xysGeB:22 a=l1rpMCqCXRGZwUSuRcM3:22 X-Proofpoint-ORIG-GUID: T3P4PylR53kCnX-whI0_cX-oMhst4mW5 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=999 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-2503190044 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_DBAP191MB1289C92E15014C2627C49BEBB0D92DBAP191MB1289EURP_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable You are right Adrian, I did not search properly I found the header file her= e: sf@toro:/opt3/dbs/pgs/17.4$ ls -l include/postgresql/server/catalog/pg_type= _d.h -rw-r--r-- 1 sf sf 9672 Mar 13 17:05 include/postgresql/server/catalog/pg_t= ype_d.h I was not expecting this file to be in a "server" folder, when it's to be u= sed for client apps. And still, I do not trust the content. Seb ________________________________ From: Adrian Klaver Sent: Tuesday, March 18, 2025 7:41 PM To: Sebastien Flaesch ; Tom Lane ; M Tarkeshwar Rao Cc: 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. On 3/16/25 02:30, Sebastien Flaesch wrote: > > Hello, > > I think the column type identification with PQftype() needs some > review/clarification. > > It's a pity that libpq does not have an API to return directly the > actual type name of a column. > > The doc > says: > > You can query the system table |pg_type| to obtain the names and > properties of the various data types. *The OIDs of the built-in data > types are defined in the file |catalog/pg_type_d.h| in the > PostgreSQL installation's |include| directory.* > > After building PostgreSQL *17.4* from the sources, I cannot find this > pg_type_d.h header file in the installation directory. Maybe I am > missing some configure option? Went I built from source in ended up in: /usr/local/pgsql/include/server/catalog/ -- Adrian Klaver adrian.klaver@aklaver.com --_000_DBAP191MB1289C92E15014C2627C49BEBB0D92DBAP191MB1289EURP_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
You are right Adrian, I did not search properly I found the header file her= e:

sf@toro:/opt3/dbs/pgs/17.4$ ls -l include/postgresql/server/catalog/pg_type= _d.h 
-rw-r--r-- 1 sf sf 9672 Mar 13 17:05 include/postgresql/server/catalog/pg_t= ype_d.h

I was not expecting this file to be in a "server" folder, when it= 's to be used for client apps.

And still, I do not trust the content.

Seb

From: Adrian Klaver <adr= ian.klaver@aklaver.com>
Sent: Tuesday, March 18, 2025 7:41 PM
To: Sebastien Flaesch <sebastien.flaesch@4js.com>; Tom Lane &l= t;tgl@sss.pgh.pa.us>; M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com= >
Cc: pgsql-general@postgresql.org <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 i= f you do not recognize the sender.

On 3/16/25 02:30, Sebastien Flaesch wrote:
>
> Hello,
>
> I think the column type identification with PQftype() needs some
> review/clarification.
>
> It's a pity that libpq does not have an API to return directly the
> actual type name of a column.
>
> The doc
> <https://urldefense.com/v3/__https://www.postgresq= l.org/docs/17/libpq-exec.html*LIBPQ-PQFTYPE__;Iw!!I_DbfM1H!BrhvYoUAjZeszdg-= ZMusy9M6WcTcHnTVpF22U_PzygM-UxQsQ0oa34TMFyp3Asr6-8L3nJQDSkUR9533wp_t-V3RsEX= lNg$ > says:
>
> You can query the system table |pg_type| to obtain the names and<= br> > properties of the various data types. *The OIDs of the built-in data > types are defined in the file |catalog/pg_type_d.h| in the
> PostgreSQL installation's |include| directory.*
>
> After building PostgreSQL *17.4* from the sources, I cannot find this<= br> > pg_type_d.h header file in the installation directory. Maybe I am
> missing some configure option?

Went I built from source in ended up in:

/usr/local/pgsql/include/server/catalog/


--
Adrian Klaver
adrian.klaver@aklaver.com



--_000_DBAP191MB1289C92E15014C2627C49BEBB0D92DBAP191MB1289EURP_--