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

--0000000000003a3f100647e2dd85
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

This is odd, I am not able to replicate...

---------------------------------------------------------------------------=
---------------------------------------------------------------------------=
---------------------------------------------------------------------------=
---------------------------------------------------------------------------=
--------------------------------------------------------------------
 POSTGIS=3D"3.6.1dev 3.6.0-6-gdb18a9a49" PGSQL=3D"180"
GEOS=3D"3.15.0dev-CAPI-1.21.0" PROJ=3D"9.3.0 NETWORK_ENABLED=3DON URL_ENDPO=
INT=3D
https://cdn.proj.org
USER_WRITABLE_DIRECTORY=3D/Users/pramsey/Library/Application Support/proj
DATABASE_PATH=3D/usr/local/share/proj/proj.db" (compiled against PROJ 9.3.0=
)
LIBXML=3D"2.9.13" LIBJSON=3D"0.17" LIBPROTOBUF=3D"1.4.1" WAGYU=3D"0.5.0 (In=
ternal)"
(1 row)

postgis_reg=3D# SELECT 'POINT EMPTY'::public.geometry =3D 'POINT
EMPTY'::public.geometry;
 ?column?
----------
 t
(1 row)


Is this a database that has gone through upgrade stages, or a blank fresh
database?

P

On Thu, Jan 8, 2026 at 8:21=E2=80=AFAM Cedric Duprez <[email protected]>=
 wrote:

> 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=3D"3.6.1 f53362=
3"
> [EXTENSION] PGSQL=3D"170" GEOS=3D"3.12.1-CAPI-1.18.1" PROJ=3D"9.4.0
> NETWORK_ENABLED=3DOFF URL_ENDPOINT=3Dhttps://cdn.proj.org
> USER_WRITABLE_DIRECTORY=3D/tmp/proj DATABASE_PATH=3D/usr/share/proj/proj.=
db"
> (compiled against PROJ 9.4.0) GDAL=3D"GDAL 3.8.4, released 2024/02/08"
> LIBXML=3D"2.9.14" LIBJSON=3D"0.17" LIBPROTOBUF=3D"1.4.1" WAGYU=3D"0.5.0 (=
Internal)"
> RASTER
>
> When I execute this query:
> SELECT 'POINT EMPTY'::public.geometry =3D 'POINT EMPTY'::public.geometry;
> I get the following error:
> ERROR: operator is not unique: public.geometry =3D 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
>

--0000000000003a3f100647e2dd85
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">This is odd, I am not able to replicate...<div><br></div><=
div>-----------------------------------------------------------------------=
---------------------------------------------------------------------------=
---------------------------------------------------------------------------=
---------------------------------------------------------------------------=
------------------------------------------------------------------------<br=
>=C2=A0POSTGIS=3D&quot;3.6.1dev 3.6.0-6-gdb18a9a49&quot; PGSQL=3D&quot;180&=
quot; GEOS=3D&quot;3.15.0dev-CAPI-1.21.0&quot; PROJ=3D&quot;9.3.0 NETWORK_E=
NABLED=3DON URL_ENDPOINT=3D<a href=3D"https://cdn.proj.org">https://cdn.pro=
j.org</a> USER_WRITABLE_DIRECTORY=3D/Users/pramsey/Library/Application Supp=
ort/proj DATABASE_PATH=3D/usr/local/share/proj/proj.db&quot; (compiled agai=
nst PROJ 9.3.0) LIBXML=3D&quot;2.9.13&quot; LIBJSON=3D&quot;0.17&quot; LIBP=
ROTOBUF=3D&quot;1.4.1&quot; WAGYU=3D&quot;0.5.0 (Internal)&quot;<br>(1 row)=
<br><br>postgis_reg=3D# SELECT &#39;POINT EMPTY&#39;::public.geometry =3D &=
#39;POINT EMPTY&#39;::public.geometry;<br>=C2=A0?column? <br>----------<br>=
=C2=A0t<br>(1 row)<br></div><div><br></div><div><br></div><div>Is this a da=
tabase that has gone through upgrade stages, or a blank fresh database?</di=
v><div><br></div><div>P</div></div><br><div class=3D"gmail_quote gmail_quot=
e_container"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, Jan 8, 2026 at 8=
:21=E2=80=AFAM Cedric Duprez &lt;<a href=3D"mailto:[email protected]">ce=
[email protected]</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote=
" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style=
:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><u></u>

 =20
  <div>
    Hi all,<br>
    <br>
    I&#39;m facing a potential bug with PostGIS 3.6.1 on PostgreSQL 17.7.<b=
r>
    Here is what I get with postgis_full_version() :=C2=A0 POSTGIS=3D&quot;=
3.6.1
    f533623&quot; [EXTENSION] PGSQL=3D&quot;170&quot; GEOS=3D&quot;3.12.1-C=
API-1.18.1&quot;
    PROJ=3D&quot;9.4.0 NETWORK_ENABLED=3DOFF URL_ENDPOINT=3D<a href=3D"http=
s://cdn.proj.org" target=3D"_blank">https://cdn.proj.org</a>
    USER_WRITABLE_DIRECTORY=3D/tmp/proj
    DATABASE_PATH=3D/usr/share/proj/proj.db&quot; (compiled against PROJ 9.=
4.0)
    GDAL=3D&quot;GDAL 3.8.4, released 2024/02/08&quot; LIBXML=3D&quot;2.9.1=
4&quot;
    LIBJSON=3D&quot;0.17&quot; LIBPROTOBUF=3D&quot;1.4.1&quot; WAGYU=3D&quo=
t;0.5.0 (Internal)&quot; RASTER<br>
    <br>
    When I execute this query:=C2=A0<br>
    SELECT &#39;POINT EMPTY&#39;::public.geometry =3D &#39;POINT
    EMPTY&#39;::public.geometry;<br>
    I get the following error:<br>
    ERROR: operator is not unique: public.geometry =3D public.geometry<br>
    <br>
    It seems to be a regression, since I didn&#39;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=3D"m_-2389229869829089874grammalecte_menu_main_button_shadow_ho=
st" style=3D"width:0px;height:0px"></div>
  </div>

</blockquote></div>

--0000000000003a3f100647e2dd85--