public inbox for [email protected]  
help / color / mirror / Atom feed
From: Ярослав Минин <[email protected]>
To: [email protected]
Subject: postgis 3.0.0 incompatibility with LLVM 15
Date: Wed, 17 Sep 2025 11:00:20 +0200
Message-ID: <CALgcmnBPLB1img8R7V=mgjsLeV0qw00efYVot0hymE9Y1oZZHg@mail.gmail.com> (raw)

Hello!

Versions:
OS: Ubuntu 22.04

PostgreSQL 15.3 (Ubuntu 15.3-1.pgdg22.04+1) on x86_64-pc-linux-gnu,
compiled by gcc (Ubuntu 11.3.0-1ubuntu1~22.04) 11.3.0, 64-bit

POSTGIS="3.6.0 4c1967d" [EXTENSION] PGSQL="150" GEOS="3.10.2-CAPI-1.16.0"
SFCGAL="SFCGAL 1.4.1, CGAL 5.3.1, BOOST 1.74.0" PROJ="8.2.1
NETWORK_ENABLED=OFF URL_ENDPOINT=https://cdn.proj.org
USER_WRITABLE_DIRECTORY=/tmp/proj DATABASE_PATH=/usr/share/proj/proj.db"
(compiled against PROJ 8.2.1) GDAL="GDAL 3.4.1, released 2021/12/27" LIBXML=
"2.9.13" LIBJSON="0.15" LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)" RASTER

After upgrading PostGIS from 3.3.0 to 3.6.0 (latest) most of our queries
result in the following error:
*error: Not an int attribute (Producer: 'LLVM15.0.7' Reader: 'LLVM 14.0.0')*
.

PostGIS was installed using *sudo apt-get install postgis
postgresql-15-postgis-3*.

It seems the problem is JIT using LLVM 14. LLVM on my PostgreSQL instance
is *'LLVM_CONFIG=/usr/bin/llvm-config-15'*.

Setting JIT=off solves the problem but we have quite many scenarios where
using JIT is let’s say prefferable.

So the question is is it possible to make PostGIS 3.3.0 compatible with my
PostgreSQL with JIT on?

--
Sincerely,
Yaras


view thread (4+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: postgis 3.0.0 incompatibility with LLVM 15
  In-Reply-To: <CALgcmnBPLB1img8R7V=mgjsLeV0qw00efYVot0hymE9Y1oZZHg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox