From: | jacktby jacktby <jacktby(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
Cc: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Subject: | Re: How to add a new pg oid? |
Date: | 2023-09-06 10:19:14 |
Message-ID: | D4E1B3AC-A010-4C06-A238-4E88052D9269@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> 2023年9月6日 01:47,David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> 写道:
>
> OIDs don't exist independently of the data they are associated with. Give more context if you want a better answer. Or just go look at the source code commits for when the last time something needing an OID got added to the core catalog.
>
> David J.
>
{ oid => '111', array_type_oid => '6099', descr => 'similarity columns',
typname => 'similarity_columns', typlen => '-1', typlen => '-1', typbyval => 'f', typcategory => 'U',
typinput => 'byteain', typoutput => 'byteaout', typreceive => 'bytearecv',
typsend => 'byteasend', typalign => 'i', typstorage => 'x' },
I add above into pg_type.dat. And then I add execute “make install” and restart pg. And Then do below:
postgres=# SELECT typname from pg_type where typname like '%similarity%';
typname
---------
(0 rows)
I can’t get the type I added. What else I need to do?
From | Date | Subject | |
---|---|---|---|
Next Message | Yura Sokolov | 2023-09-06 10:24:20 | Re: Vectorization of some functions and improving pg_list interface |
Previous Message | Suraj Kharage | 2023-09-06 10:00:21 | Re: [Regression] Incorrect filename in test case comment |