pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedPossible bug ¿? missing "ucol.h" in postgre installation
4+ messages / 2 participants
[nested] [flat]
* Possible bug ¿? missing "ucol.h" in postgre installation
@ 2025-02-17 19:18 Jose Fco. Mojada <jfmojada@yahoo.es>
2025-02-17 19:47 ` Re: Possible bug ¿? missing "ucol.h" in postgre installation Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Jose Fco. Mojada @ 2025-02-17 19:18 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org
Hi guys !
Please forgive me if I do not do it correctly, it is the first time that
I write to this list and not know if I do it properly.
We have a problem with a PostgreSQL 16 installation, I am preparing this
server to be the destination for the migration of another database in
PostgreSQL 15, the details of the versions are:
15.8 -> 16.7
As an example, we take the attempt to install the "orafce" extension in
the new system, although it is not the only one in which this happens.
When installing, we get the following error:
/usr/pgsql-16/include/server/utils/pg_locale.h:19:10: fatal error:
unicode/ucol.h: No such file or directory
19 | #include <unicode/ucol.h>
| ^~~~~~~~~~~~~~~~
When reviewing the file:
"//usr/pgsql-16/include/server/utils/pg_locale.h/" We see the references
to the missing file "ucol.h". We are looking for this last file:
* In our system
* In AlmaLinux repositories
* In Red Hat repositories
* In RPM find
* With the help of rpm and yum command
We didn't find any reference to it anywhere except on github: (
https://github.com/unicode-org/icu/blob/main/icu4c/source/i18n/unicode/ucol.h
).
The fact is that we reviewed the other server that we have in version
15.8 and this file does not exist either, but nevertheless we have not
had problems installing the following extensions:
postgres=# \dx
Listado de extensiones instaladas
Nombre | Versión | Esquema
| Descripción
--------------------+---------+------------+-----------------------------------------------------------------------------------------------
dblink | 1.2 | public | connect to other
PostgreSQL databases from within a database
orafce | 4.12 | public | Functions and operators
that emulate a subset of functions and packages from the Oracle RDBMS
pg_buffercache | 1.3 | public | examine the shared buffer
cache
pg_cron | 1.6 | pg_catalog | Job scheduler for
PostgreSQL
pg_hint_plan | 1.5.2 | hint_plan |
pg_partman | 5.1.0 | public | Extension to manage
partitioned tables by time or ID
pg_prewarm | 1.2 | public | prewarm relation data
pg_stat_statements | 1.10 | public | track planning and
execution statistics of all SQL statements executed
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural
language
vector | 0.7.4 | public | vector data type and
ivfflat and hnsw access methods
(10 filas)
Attached:
* A system file with PostgreSQL 15 and another file with the
PostgreSQL 16 system with the following data:
o Version revision
o List of installed extensions
o Search with the "root" user for the "ucol.h" file
o Complete OS release
* List of "*.h" files that are distributed with the installation of
postgreSQL in "//usr/pgsql-15/include/server/utils/" and
"//usr/pgsql-16/include/server/utils/" respectively
* We also attach a file for each system, one from the PostgreSQL
server 15 and another from 16 with the list of all the RPM packages
installed in the OS.
I also found information that requests the packages
"/icu-67.1-9.el9.x86_64/" and "/libicu-67.1-9.el9.x86_64/" to be
installed, but these do not solve the problem on my system. I even tried
to edit the "/pg_locale.h" /file to remove these references, but I’m not
familiar with the source code and logically make a lot of mistakes.
I think this is an error, or maybe a bug, since there are changes in the
"/pg_locale.h/" file of both versions (I attach the output of the diff
command), and one thing that has surprised me a lot, is that the package
"dev" of the postgreSQL version was not well in the repository of my
linux distribution ( Rocky / Alma / RH ) , and I had to download it
directly from the web of the postgreSQL project, Could there be bugs or
errors? , would it be possible to take the file "/pg_locale. h/" from an
earlier version?
Thank you very much in advance!
Regards ,
Jose Mojada
Attachments:
Files.zip (application/zip, 26.1K) download
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Possible bug ¿? missing "ucol.h" in postgre installation
2025-02-17 19:18 Possible bug ¿? missing "ucol.h" in postgre installation Jose Fco. Mojada <jfmojada@yahoo.es>
@ 2025-02-17 19:47 ` Tom Lane <tgl@sss.pgh.pa.us>
2025-02-17 20:16 ` Re: Possible bug ¿? missing "ucol.h" in postgre installation Jose Fco. Mojada <jfmojada@yahoo.es>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2025-02-17 19:47 UTC (permalink / raw)
To: Jose Fco. Mojada <jfmojada@yahoo.es>; +Cc: pgsql-bugs@lists.postgresql.org
"Jose Fco. Mojada" <jfmojada@yahoo.es> writes:
> As an example, we take the attempt to install the "orafce" extension in
> the new system, although it is not the only one in which this happens.
> When installing, we get the following error:
> /usr/pgsql-16/include/server/utils/pg_locale.h:19:10: fatal error:
> unicode/ucol.h: No such file or directory
> 19 | #include <unicode/ucol.h>
> | ^~~~~~~~~~~~~~~~
On my Red Hat system, /usr/include/unicode/ucol.h is provided by
libicu-devel. You need to install that package, not only the
base libicu package, to compile anything that uses libicu.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Possible bug ¿? missing "ucol.h" in postgre installation
2025-02-17 19:18 Possible bug ¿? missing "ucol.h" in postgre installation Jose Fco. Mojada <jfmojada@yahoo.es>
2025-02-17 19:47 ` Re: Possible bug ¿? missing "ucol.h" in postgre installation Tom Lane <tgl@sss.pgh.pa.us>
@ 2025-02-17 20:16 ` Jose Fco. Mojada <jfmojada@yahoo.es>
2025-02-19 19:14 ` Re: Possible bug ¿? missing "ucol.h" in postgre installation Jose Fco. Mojada <jfmojada@yahoo.es>
0 siblings, 1 reply; 4+ messages in thread
From: Jose Fco. Mojada @ 2025-02-17 20:16 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org
Hi Tom,
Thanks a lot for the fast answer ! I will try !
Thank you very much !
Regards !
Jose Mojada
El 17/2/25 a las 20:47, Tom Lane escribió:
> "Jose Fco. Mojada" <jfmojada@yahoo.es> writes:
>> As an example, we take the attempt to install the "orafce" extension in
>> the new system, although it is not the only one in which this happens.
>> When installing, we get the following error:
>> /usr/pgsql-16/include/server/utils/pg_locale.h:19:10: fatal error:
>> unicode/ucol.h: No such file or directory
>> 19 | #include <unicode/ucol.h>
>> | ^~~~~~~~~~~~~~~~
> On my Red Hat system, /usr/include/unicode/ucol.h is provided by
> libicu-devel. You need to install that package, not only the
> base libicu package, to compile anything that uses libicu.
>
> regards, tom lane
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Possible bug ¿? missing "ucol.h" in postgre installation
2025-02-17 19:18 Possible bug ¿? missing "ucol.h" in postgre installation Jose Fco. Mojada <jfmojada@yahoo.es>
2025-02-17 19:47 ` Re: Possible bug ¿? missing "ucol.h" in postgre installation Tom Lane <tgl@sss.pgh.pa.us>
2025-02-17 20:16 ` Re: Possible bug ¿? missing "ucol.h" in postgre installation Jose Fco. Mojada <jfmojada@yahoo.es>
@ 2025-02-19 19:14 ` Jose Fco. Mojada <jfmojada@yahoo.es>
0 siblings, 0 replies; 4+ messages in thread
From: Jose Fco. Mojada @ 2025-02-19 19:14 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org
Hi Tom,
Thank you very much for your help ! Finally it works for me, you have de
reason :)
Regards !
Jose Mojada
El 17/2/25 a las 21:16, Jose Fco. Mojada escribió:
> Hi Tom,
>
> Thanks a lot for the fast answer ! I will try !
>
> Thank you very much !
>
> Regards !
>
> Jose Mojada
>
>
>
> El 17/2/25 a las 20:47, Tom Lane escribió:
>> "Jose Fco. Mojada" <jfmojada@yahoo.es> writes:
>>> As an example, we take the attempt to install the "orafce" extension in
>>> the new system, although it is not the only one in which this happens.
>>> When installing, we get the following error:
>>> /usr/pgsql-16/include/server/utils/pg_locale.h:19:10: fatal error:
>>> unicode/ucol.h: No such file or directory
>>> 19 | #include <unicode/ucol.h>
>>> | ^~~~~~~~~~~~~~~~
>> On my Red Hat system, /usr/include/unicode/ucol.h is provided by
>> libicu-devel. You need to install that package, not only the
>> base libicu package, to compile anything that uses libicu.
>>
>> regards, tom lane
>>
>>
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2025-02-19 19:14 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-02-17 19:18 Possible bug ¿? missing "ucol.h" in postgre installation Jose Fco. Mojada <jfmojada@yahoo.es>
2025-02-17 19:47 ` Tom Lane <tgl@sss.pgh.pa.us>
2025-02-17 20:16 ` Jose Fco. Mojada <jfmojada@yahoo.es>
2025-02-19 19:14 ` Jose Fco. Mojada <jfmojada@yahoo.es>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox