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

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

On Thu, Jan 8, 2026 at 9:15=E2=80=AFAM Regina Obe <[email protected]> wrote:

> Cedric,
>
>
>
> Good news.  I was able to replicate.
>
>
>
> I noticed in your output you have the fully qualified type name, which
> means you don=E2=80=99t have postgis schema in your search path.
>
>
>
> To replicate I did:
>
>
>
> set search_path=3D'pg_catalog';
>
> SELECT 'POINT EMPTY'::public.geometry =3D 'POINT EMPTY'::public.geometry;
>
>
>
>
>
> Gives:
>
>
>
> ERROR: operator is not unique: public.geometry =3D public.geometry LINE 1=
:
> SELECT 'POINT EMPTY'::public.geometry =3D 'POINT EMPTY'::publi... ^
>
>
>
>
>
> So I=E2=80=99m guessing we have some code in our =3D path that is not sch=
ema
> qualified.
>
>
>
> I=E2=80=99ve ticketed the issue here:
>
>
>
> https://trac.osgeo.org/postgis/ticket/6033
>
>
>
> Paul,
>
> Can you confirm you can replicate by changing your search_path?
>
>
>

Yes, that replicates on my pg18 also.

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

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote g=
mail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, Jan 8, =
2026 at 9:15=E2=80=AFAM Regina Obe &lt;<a href=3D"mailto:[email protected]">lr@pc=
orp.us</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"m=
argin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;borde=
r-left-color:rgb(204,204,204);padding-left:1ex"><div class=3D"msg-225962572=
3582995221"><div lang=3D"EN-US" style=3D"overflow-wrap: break-word;"><div c=
lass=3D"m_-2259625723582995221WordSection1"><p class=3D"MsoNormal">Cedric,<=
u></u><u></u></p><p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p><p class=3D=
"MsoNormal">Good news.=C2=A0 I was able to replicate.<u></u><u></u></p><p c=
lass=3D"MsoNormal"><u></u>=C2=A0<u></u></p><p class=3D"MsoNormal">I noticed=
 in your output you have the fully qualified type name, which means you don=
=E2=80=99t have postgis schema in your search path.<u></u><u></u></p><p cla=
ss=3D"MsoNormal"><u></u>=C2=A0<u></u></p><p class=3D"MsoNormal">To replicat=
e I did:<u></u><u></u></p><p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p><p=
 class=3D"MsoNormal">set search_path=3D&#39;pg_catalog&#39;;<u></u><u></u><=
/p><p class=3D"MsoNormal">SELECT &#39;POINT EMPTY&#39;::public.geometry =3D=
 &#39;POINT EMPTY&#39;::public.geometry;<u></u><u></u></p><p class=3D"MsoNo=
rmal"><u></u>=C2=A0<u></u></p><p class=3D"MsoNormal"><u></u>=C2=A0<u></u></=
p><p class=3D"MsoNormal">Gives:<u></u><u></u></p><p class=3D"MsoNormal"><u>=
</u>=C2=A0<u></u></p><p class=3D"MsoNormal">ERROR: operator is not unique: =
public.geometry =3D public.geometry LINE 1: SELECT &#39;POINT EMPTY&#39;::p=
ublic.geometry =3D &#39;POINT EMPTY&#39;::publi... ^<u></u><u></u></p><p cl=
ass=3D"MsoNormal"><u></u>=C2=A0<u></u></p><p class=3D"MsoNormal"><u></u>=C2=
=A0<u></u></p><p class=3D"MsoNormal">So I=E2=80=99m guessing we have some c=
ode in our =3D path that is not schema qualified.<u></u><u></u></p><p class=
=3D"MsoNormal"><u></u>=C2=A0<u></u></p><p class=3D"MsoNormal">I=E2=80=99ve =
ticketed the issue here:<u></u><u></u></p><p class=3D"MsoNormal"><u></u>=C2=
=A0<u></u></p><p class=3D"MsoNormal"><a href=3D"https://trac.osgeo.org/post=
gis/ticket/6033" target=3D"_blank">https://trac.osgeo.org/postgis/ticket/60=
33</a><u></u><u></u></p><p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p><p c=
lass=3D"MsoNormal">Paul,<u></u><u></u></p><p class=3D"MsoNormal">Can you co=
nfirm you can replicate by changing your search_path?<u></u><u></u></p><p c=
lass=3D"MsoNormal"><u></u>=C2=A0</p></div></div></div></blockquote><div><br=
></div><div>Yes, that replicates on my pg18 also.=C2=A0</div></div></div>

--000000000000da32960647e3daa5--