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

[Cedric Duprez]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20260108/26e63058/attachment.htm>