Feedback-ID: i76984098:Fastmail
Message-ID: <7a07f957-bb8c-413b-806a-504a5cd12072@aklaver.com>
Date: Wed, 19 Mar 2025 09:53:31 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: After upgrading libpq, the same function(PQftype) call returns a
 different OID
To: Sebastien Flaesch <sebastien.flaesch@4js.com>,
 Tom Lane <tgl@sss.pgh.pa.us>,
 M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>
Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
References: <PAWPR07MB1009569596278D85AC691BBF4AEDD2@PAWPR07MB10095.eurprd07.prod.outlook.com>
 <3498256.1742065328@sss.pgh.pa.us>
 <DBAP191MB1289124F5D8690DF3F72F62CB0DC2@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM>
 <295e06b4-ff5d-4d82-ba56-1bab24be6bbc@aklaver.com>
 <DBAP191MB1289C92E15014C2627C49BEBB0D92@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <DBAP191MB1289C92E15014C2627C49BEBB0D92@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/7a07f957-bb8c-413b-806a-504a5cd12072%40aklaver.com>
Precedence: bulk

On 3/18/25 23:41, Sebastien Flaesch wrote:
> You are right Adrian, I did not search properly I found the header file 
> here:
> 
> 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_type_d.h
> 
> I was not expecting this file to be in a "server" folder, when it's to 
> be used for client apps.

Not surprising. As I understand it this is the code used to build the 
type entries in the system catalog pg_type. As was mentioned in your 
previous link:

https://www.postgresql.org/docs/17/libpq-exec.html#LIBPQ-PQFTYPE

the suggested way to get type information is:

"You can query the system table pg_type to obtain the names and 
properties of the various data types. "

> 
> And still, I do not trust the content.

Then do as suggested above.

> 
> Seb
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com