PostGIS 3.6.1 - ERROR: operator is not unique: public.geometry = public.geometry

Cedric Duprez <[email protected]> Thu, 8 Jan 2026 17:20:58 +0100
Newsgroups gmane.comp.gis.postgis
Message-ID <[email protected]> 
--------------Rrw2E9kPobsY5kQ1JOLWoFW2
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Hi all,

I'm facing a potential bug with PostGIS 3.6.1 on PostgreSQL 17.7.
Here is what I get with postgis_full_version() :  POSTGIS="3.6.1 
f533623" [EXTENSION] PGSQL="170" GEOS="3.12.1-CAPI-1.18.1" PROJ="9.4.0 
NETWORK_ENABLED=OFF URL_ENDPOINT=https://cdn.proj.org 
USER_WRITABLE_DIRECTORY=/tmp/proj DATABASE_PATH=/usr/share/proj/proj.db" 
(compiled against PROJ 9.4.0) GDAL="GDAL 3.8.4, released 2024/02/08" 
LIBXML="2.9.14" LIBJSON="0.17" LIBPROTOBUF="1.4.1" WAGYU="0.5.0 
(Internal)" RASTER

When I execute this query:
SELECT 'POINT EMPTY'::public.geometry = 'POINT EMPTY'::public.geometry;
I get the following error:
ERROR: operator is not unique: public.geometry = public.geometry

It seems to be a regression, since I didn't have this error on previous 
versions of PostGIS (3.5).

How can this problem be solved?
Thanks in advance for you help,

Cedric
--------------Rrw2E9kPobsY5kQ1JOLWoFW2
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html><html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body>
    Hi all,<br>
    <br>
    I'm facing a potential bug with PostGIS 3.6.1 on PostgreSQL 17.7.<br>
    Here is what I get with postgis_full_version() :&nbsp; POSTGIS=&quot;3.6.1
    f533623&quot; [EXTENSION] PGSQL=&quot;170&quot; GEOS=&quot;3.12.1-CAPI-1.18.1&quot;
    PROJ=&quot;9.4.0 NETWORK_ENABLED=OFF URL_ENDPOINT=<a class="moz-txt-link-freetext" href="https://cdn.proj.org">https://cdn.proj.org</a>
    USER_WRITABLE_DIRECTORY=/tmp/proj
    DATABASE_PATH=/usr/share/proj/proj.db&quot; (compiled against PROJ 9.4.0)
    GDAL=&quot;GDAL 3.8.4, released 2024/02/08&quot; LIBXML=&quot;2.9.14&quot;
    LIBJSON=&quot;0.17&quot; LIBPROTOBUF=&quot;1.4.1&quot; WAGYU=&quot;0.5.0 (Internal)&quot; RASTER<br>
    <br>
    When I execute this query:&nbsp;<br>
    SELECT 'POINT EMPTY'::public.geometry = 'POINT
    EMPTY'::public.geometry;<br>
    I get the following error:<br>
    ERROR: operator is not unique: public.geometry = public.geometry<br>
    <br>
    It seems to be a regression, since I didn't have this error on
    previous versions of PostGIS (3.5).<br>
    <br>
    How can this problem be solved?<br>
    Thanks in advance for you help,<br>
    <br>
    Cedric
    <div id="grammalecte_menu_main_button_shadow_host" style="width: 0px; height: 0px;"></div>
  </body>
</html>

--------------Rrw2E9kPobsY5kQ1JOLWoFW2--