<!DOCTYPE html><html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<font face="Helvetica, Arial, sans-serif">Hi Paul,<br>
<br>
Thanks for your answer.<br>
The database was restored from a cold physical backup (PGDATA
copy).<br>
<br>
Cedric<br>
</font><br>
<div class="moz-cite-prefix">Le 08/01/2026 à 17:25, Paul Ramsey a
écrit :<br>
</div>
<blockquote type="cite" cite="mid:CACowWR1rTX7t=+KOKer5Dc+CyRKOacv5xwMVt_Ef1spWSeFZfw@mail.gmail.com">
<div dir="ltr">This is odd, I am not able to replicate...
<div><br>
</div>
<div>--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br>
POSTGIS="3.6.1dev 3.6.0-6-gdb18a9a49" PGSQL="180"
GEOS="3.15.0dev-CAPI-1.21.0" PROJ="9.3.0 NETWORK_ENABLED=ON
URL_ENDPOINT=<a href="https://cdn.proj.org" moz-do-not-send="true" class="moz-txt-link-freetext">https://cdn.proj.org</a>
USER_WRITABLE_DIRECTORY=/Users/pramsey/Library/Application
Support/proj DATABASE_PATH=/usr/local/share/proj/proj.db"
(compiled against PROJ 9.3.0) LIBXML="2.9.13" LIBJSON="0.17"
LIBPROTOBUF="1.4.1" WAGYU="0.5.0 (Internal)"<br>
(1 row)<br>
<br>
postgis_reg=# SELECT 'POINT EMPTY'::public.geometry = 'POINT
EMPTY'::public.geometry;<br>
?column? <br>
----------<br>
t<br>
(1 row)<br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>Is this a database that has gone through upgrade stages, or
a blank fresh database?</div>
<div><br>
</div>
<div>P</div>
</div>
<br>
<div class="gmail_quote gmail_quote_container">
<div dir="ltr" class="gmail_attr">On Thu, Jan 8, 2026 at 8:21 AM
Cedric Duprez <<a href="mailto:cedric.duprez@ign.fr" moz-do-not-send="true" class="moz-txt-link-freetext">cedric.duprez@ign.fr</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div> 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() :
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=<a href="https://cdn.proj.org" target="_blank" moz-do-not-send="true" class="moz-txt-link-freetext">https://cdn.proj.org</a>
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<br>
<br>
When I execute this query: <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>
</blockquote>
</div>
</blockquote>
<br>
<div id="grammalecte_menu_main_button_shadow_host" style="width: 0px; height: 0px;"></div>
</body>
</html>