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

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

No, this is clearly a postgres/postgis thing, it doesn't hit on geos or
proj code lines. I was testing with pg18, but I see now Regina has
replicated on pg17 also, so that was the one thing I was working on
clarifying in terms of reproduction.

P

On Thu, Jan 8, 2026 at 8:54=E2=80=AFAM Arthur Bazin <[email protected]>=
 wrote:

> @paul, you have not the exact same version of PostGIS and therefore of
> GEOS and PROJ.
> Maybe the origin of the non reproductibility ?
>
> Best regards
> Arthur
>
>
>
> Le jeu. 8 janv. 2026, 17:26, Paul Ramsey via postgis-users <
> [email protected]> a =C3=A9crit :
>
>> 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_EN=
DPOINT=3D
>> https://cdn.proj.org
>> USER_WRITABLE_DIRECTORY=3D/Users/pramsey/Library/Application Support/pro=
j
>> 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 =
(Internal)"
>> (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 fres=
h
>> database?
>>
>> P
>>
>> On Thu, Jan 8, 2026 at 8:21=E2=80=AFAM Cedric Duprez <cedric.duprez@ign.=
fr>
>> 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
>>> f533623" [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/pro=
j.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.geometr=
y;
>>> 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
>>>
>>

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

<div dir=3D"ltr">No, this is clearly a postgres/postgis thing, it doesn&#39=
;t hit on geos or proj code lines. I was testing with pg18, but I see now R=
egina has replicated on pg17 also, so that was the one thing I was working =
on clarifying in terms of reproduction.<div><br></div><div>P</div></div><br=
><div class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D=
"gmail_attr">On Thu, Jan 8, 2026 at 8:54=E2=80=AFAM Arthur Bazin &lt;<a hre=
f=3D"mailto:[email protected]">[email protected]</a>&gt; wrote:<br>=
</div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;b=
order-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,=
204);padding-left:1ex"><div dir=3D"auto"><div dir=3D"auto"><div>@paul, you =
have not the exact same version of PostGIS and therefore of GEOS and PROJ.=
=C2=A0</div><div dir=3D"auto">Maybe the origin of the non reproductibility =
?=C2=A0</div><div dir=3D"auto"><br></div><div dir=3D"auto">Best regards</di=
v><div dir=3D"auto">Arthur</div><div dir=3D"auto"><br></div><div dir=3D"aut=
o"><br></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D=
"gmail_attr">Le jeu. 8 janv. 2026, 17:26, Paul Ramsey via postgis-users &lt=
;<a href=3D"mailto:[email protected]" rel=3D"noreferrer" target=
=3D"_blank">[email protected]</a>&gt; a =C3=A9crit=C2=A0:<br></=
div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bor=
der-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,20=
4);padding-left:1ex"><div dir=3D"ltr">This is odd, I am not able to replica=
te...<div><br></div><div>--------------------------------------------------=
---------------------------------------------------------------------------=
---------------------------------------------------------------------------=
---------------------------------------------------------------------------=
---------------------------------------------------------------------------=
------------------<br>=C2=A0POSTGIS=3D&quot;3.6.1dev 3.6.0-6-gdb18a9a49&quo=
t; PGSQL=3D&quot;180&quot; GEOS=3D&quot;3.15.0dev-CAPI-1.21.0&quot; PROJ=3D=
&quot;9.3.0 NETWORK_ENABLED=3DON URL_ENDPOINT=3D<a href=3D"https://cdn.proj=
.org" rel=3D"noreferrer noreferrer" target=3D"_blank">https://cdn.proj.org<=
/a> USER_WRITABLE_DIRECTORY=3D/Users/pramsey/Library/Application Support/pr=
oj DATABASE_PATH=3D/usr/local/share/proj/proj.db&quot; (compiled against PR=
OJ 9.3.0) LIBXML=3D&quot;2.9.13&quot; LIBJSON=3D&quot;0.17&quot; LIBPROTOBU=
F=3D&quot;1.4.1&quot; WAGYU=3D&quot;0.5.0 (Internal)&quot;<br>(1 row)<br><b=
r>postgis_reg=3D# SELECT &#39;POINT EMPTY&#39;::public.geometry =3D &#39;PO=
INT EMPTY&#39;::public.geometry;<br>=C2=A0?column? <br>----------<br>=C2=A0=
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=3D"gmail_quote"><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]" rel=3D"noreferrer noreferrer" =
target=3D"_blank">[email protected]</a>&gt; wrote:<br></div><blockquote =
class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1=
px;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" rel=3D"noreferrer noreferrer" target=3D"_blank">https://c=
dn.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></blockquote></div></blockquote></div><div><div dir=3D"ltr"=
><div dir=3D"ltr"><table style=3D"font-family:&quot;trebuchet ms&quot;,taho=
ma,sans-serif;font-size:11px;line-height:11px;color:rgb(76,0,151);margin:10=
px 0px;border-spacing:0px;border:1px solid rgb(238,237,237)">
	<tbody>
		<tr style=3D"height:15px">
			<td colspan=3D"3"></td></tr>
	</tbody>
</table></div></div></div></div>
</blockquote></div>

--000000000000cdf7b60647e368f3--