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 1tvDSg-002EmP-8M for pgsql-general@arkaria.postgresql.org; Thu, 20 Mar 2025 10:49:18 +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 1tvDRg-0027yT-LV for pgsql-general@arkaria.postgresql.org; Thu, 20 Mar 2025 10:48:16 +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 1tvDRg-0027yK-Ak for pgsql-general@lists.postgresql.org; Thu, 20 Mar 2025 10:48:16 +0000 Received: from mail-oi1-x232.google.com ([2607:f8b0:4864:20::232]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tvDRe-0006tw-1z for pgsql-general@postgresql.org; Thu, 20 Mar 2025 10:48:15 +0000 Received: by mail-oi1-x232.google.com with SMTP id 5614622812f47-3f422d6e3b0so114608b6e.1 for ; Thu, 20 Mar 2025 03:48:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1742467694; x=1743072494; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=WXTbtGyfIZ7+9RqFgYJdzN3i0r7e20BQTIAs4c6clLs=; b=he5ZXP4oclEoTyYwyc8iCR5WjXL6PofdsJ08Fho+SLeLiA767e332D+HX/C9XCNLK2 r/ahCwhxEbFqpIJQLYYSQ1JjjHpl79+tvIUZ0NhYhe1gwt+xeA0B5sWFD+bUHo18SRAA reym2Yq6btUs5qdIFFg//k90yZdcrEFKu8blTOPLwbgz52NPxSZzd6J89CYAts+OK6B2 M41w6YEaLHc5hlNK+37PsROgv+l28viAA84hWippZOqyVNYY9ids4gGbTEOP5cLrNTaQ hfFbpZRhCqRT69wtbe3yyOEPGRrCSIqm9J+U/mO8mgd8UnV+x6UZd5YqfsxBqmiOWIfT BEQg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1742467694; x=1743072494; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=WXTbtGyfIZ7+9RqFgYJdzN3i0r7e20BQTIAs4c6clLs=; b=QugqkepM1Z0qDKdicUl9eIISjiNgX+21f9dJEriTKLSwqen7k/Y0K3/kjF8XaHETRY wbqXw+YNT/r96SrbUW7LYmbiRs0pn3vU/kf+ymVO28AHx6woDNE6KXwxFxIrqQWxO4bo JD0xEbOHCr3lk+nugSP6e1vd2+LWsRuHIRGhgmGjy6HWBjAaETmfEyWvfrbZNNnmOe9o Q59V7A8qP3E7L45VABZ7+XHxdDSPvNkITjo6rZVLwJJ7KP9J63aq1eu4KEpkR2QeLayp TDPnas8NpXBtQFx/6/JbhJNuj90J4Tfw9h5kjK3hgdGKK2yZKj4fhkXqrO/2towTWr8o oP7A== X-Gm-Message-State: AOJu0Yz30lhLX7Z8zaHjWKGHHUGZ4gpkwPpX4/z/AXIHFCBbKGQ9ngna Q5IPK5FPKG4z4Ny5FFTxHp0+hNnqpSROE0+/4tsVr9Plchl36o+r444Mdz/RGHqbHYaeO518S1b 1/uJ2Xaf95ZHzJQvje0kGkkv+hZa4Ale5 X-Gm-Gg: ASbGncsIhsHo2M6I9C4aRq5+thUT2pr80aEPX5eoGFU7XQ+FQutyaOm+jpd8QZKzSAI knFhbnAjWfqQOhT75Uvaxyt9FwzaNINRn0lZw3ZbIAZ+Gv08kSg4KvMiMbsHoGfVyJJMKTEPU2N reqwGOx2AlPb5XIr8uHsKNuKg1 X-Google-Smtp-Source: AGHT+IH+ISRo+1j+e70kkQDSF4GCuhaatzX+jQNqJjP1rNBb7xCMfb2+VaB9grV31kKIeAQr47yoUkZ39UD73aKK+3k= X-Received: by 2002:a05:6808:1710:b0:3f4:21af:6d45 with SMTP id 5614622812f47-3fead5865afmr4721740b6e.12.1742467693794; Thu, 20 Mar 2025 03:48:13 -0700 (PDT) MIME-Version: 1.0 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> In-Reply-To: From: Luca Ferrari Date: Thu, 20 Mar 2025 11:47:37 +0100 X-Gm-Features: AQ5f1Jqul6P7KTZ7DMATr1GT3ubA0egMNf_2Grs6mMw7JDns4kCAMX9QUqj-ou4 Message-ID: Subject: Re: After upgrading libpq, the same function(PQftype) call returns a different OID To: Sebastien Flaesch Cc: "pgsql-general@postgresql.org" Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Mar 20, 2025 at 8:18=E2=80=AFAM Sebastien Flaesch wrote: > > Let's not deviate from my request: > > I have implemented various DB client modules using the C client APIs, for= Oracle DB, SQL Server, IBM DB2, MySQL/MariaDB, SQLite and PostgreSQL. > Good for you! I don't think anybody is trying to deviate from your request, the point is as described in the documentation of PQftype you have been already pointed out. And according to me, the approach is flexible enough to allow for extending the type system without problems. Last, it is not clear to me what the original problem (getting a different oid from your libpq example) was generated from: did you queried the catalog? Luca