Re: PostGIS 3.6.1 - ERROR: operator is not unique: public.geometry = public.geometry
Arthur Bazin <[email protected]> Thu, 8 Jan 2026 18:06:45 +0100
| Newsgroups | gmane.comp.gis.postgis |
|---|---|
| Message-ID | <CABjE6y1v=qeFk5fg7ki7wqEhwgoy7ERSCUdxvPb97JYWtWuq3g@mail.gmail.com> |
--000000000000ae5b940647e36fdf Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Havn't tried for now but will do it tomorrow if not resolve at this time :-) It was Just a suggestion. Keep you informed Le jeu. 8 janv. 2026, 18:01, Regina Obe <[email protected]> a =C3=A9crit : > Arthur, > > > > Are you able to replicate? I can=E2=80=99t with the same version of Post= GIS and > PostgreSQL. > > > > *From:* Arthur Bazin <[email protected]> > *Sent:* Thursday, January 8, 2026 11:55 AM > *To:* Paul Ramsey <[email protected]> > *Cc:* PostGIS Users Discussion <[email protected]> > *Subject:* Re: PostGIS 3.6.1 - ERROR: operator is not unique: > public.geometry =3D public.geometry > > > > @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_END= POINT=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 (= 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 fresh > database? > > > > P > > > > On Thu, Jan 8, 2026 at 8:21=E2=80=AFAM Cedric Duprez <[email protected]= r> 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 > > > --000000000000ae5b940647e36fdf Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"auto"><div>Havn't tried for now but will do it tomorrow if = not resolve at this time :-)=C2=A0</div><div dir=3D"auto"><br></div><div>It= was Just a suggestion.=C2=A0</div><div dir=3D"auto">Keep you informed=C2= =A0</div><div data-smartmail=3D"gmail_signature"><div dir=3D"ltr"><div dir= =3D"ltr"><br><table style=3D"font-family:trebuchet ms,tahoma,sans-serif;fon= t-size:11px;line-height:11px;color:rgb(76,0,151);margin:10px 0px;border-spa= cing:0px;border:1px solid rgb(238,237,237)"><tbody> </tbody> </table></div></div></div></div><br><div class=3D"gmail_quote gmail_quote_c= ontainer"><div dir=3D"ltr" class=3D"gmail_attr">Le jeu. 8 janv. 2026, 18:01= , Regina Obe <<a href=3D"mailto:[email protected]">[email protected]</a>> a =C3= =A9crit=C2=A0:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0= 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang=3D"EN-US" = link=3D"blue" vlink=3D"purple" style=3D"word-wrap:break-word"><div class=3D= "m_7562609471620292577WordSection1"><p class=3D"MsoNormal">Arthur,<u></u><u= ></u></p><p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p><p class=3D"MsoNorm= al">Are you able to replicate?=C2=A0 I can=E2=80=99t with the same version = of PostGIS and PostgreSQL.<u></u><u></u></p><p class=3D"MsoNormal"><u></u>= =C2=A0<u></u></p><div style=3D"border:none;border-left:solid blue 1.5pt;pad= ding:0in 0in 0in 4.0pt"><div><div style=3D"border:none;border-top:solid #e1= e1e1 1.0pt;padding:3.0pt 0in 0in 0in"><p class=3D"MsoNormal"><b><span style= =3D"font-size:11.0pt;font-family:"Calibri",sans-serif">From:</spa= n></b><span style=3D"font-size:11.0pt;font-family:"Calibri",sans-= serif"> Arthur Bazin <<a href=3D"mailto:[email protected]" target=3D= "_blank" rel=3D"noreferrer">[email protected]</a>> <br><b>Sent:</b> = Thursday, January 8, 2026 11:55 AM<br><b>To:</b> Paul Ramsey <<a href=3D= "mailto:[email protected]" target=3D"_blank" rel=3D"noreferrer">pra= [email protected]</a>><br><b>Cc:</b> PostGIS Users Discussion <<= a href=3D"mailto:[email protected]" target=3D"_blank" rel=3D"no= referrer">[email protected]</a>><br><b>Subject:</b> Re: Post= GIS 3.6.1 - ERROR: operator is not unique: public.geometry =3D public.geome= try<u></u><u></u></span></p></div></div><p class=3D"MsoNormal"><u></u>=C2= =A0<u></u></p><div><div><div><p class=3D"MsoNormal">@paul, you have not the= exact same version of PostGIS and therefore of GEOS and PROJ.=C2=A0<u></u>= <u></u></p></div><div><p class=3D"MsoNormal">Maybe the origin of the non re= productibility ?=C2=A0<u></u><u></u></p></div><div><p class=3D"MsoNormal"><= u></u>=C2=A0<u></u></p></div><div><p class=3D"MsoNormal">Best regards<u></u= ><u></u></p></div><div><p class=3D"MsoNormal">Arthur<u></u><u></u></p></div= ><div><p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p></div><div><p class=3D= "MsoNormal"><u></u>=C2=A0<u></u></p></div></div><p class=3D"MsoNormal"><u><= /u>=C2=A0<u></u></p><div><div><p class=3D"MsoNormal">Le jeu. 8 janv. 2026, = 17:26, Paul Ramsey via postgis-users <<a href=3D"mailto:postgis-users@li= sts.osgeo.org" target=3D"_blank" rel=3D"noreferrer">[email protected]= eo.org</a>> a =C3=A9crit=C2=A0:<u></u><u></u></p></div><blockquote style= =3D"border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;m= argin-left:4.8pt;margin-right:0in"><div><p class=3D"MsoNormal">This is odd,= I am not able to replicate...<u></u><u></u></p><div><p class=3D"MsoNormal"= ><u></u>=C2=A0<u></u></p></div><div><p class=3D"MsoNormal">----------------= ---------------------------------------------------------------------------= ---------------------------------------------------------------------------= ---------------------------------------------------------------------------= ---------------------------------------------------------------------------= ----------------------------------------------------<br>=C2=A0POSTGIS=3D&qu= ot;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_ENDP= OINT=3D<a href=3D"https://cdn.proj.org" target=3D"_blank" rel=3D"noreferrer= ">https://cdn.proj.org</a> USER_WRITABLE_DIRECTORY=3D/Users/pramsey/Library= /Application Support/proj DATABASE_PATH=3D/usr/local/share/proj/proj.db&quo= t; (compiled against PROJ 9.3.0) LIBXML=3D"2.9.13" LIBJSON=3D&quo= t;0.17" LIBPROTOBUF=3D"1.4.1" WAGYU=3D"0.5.0 (Internal)= "<br>(1 row)<br><br>postgis_reg=3D# SELECT 'POINT EMPTY'::publ= ic.geometry =3D 'POINT EMPTY'::public.geometry;<br>=C2=A0?column? <= br>----------<br>=C2=A0t<br>(1 row)<u></u><u></u></p></div><div><p class=3D= "MsoNormal"><u></u>=C2=A0<u></u></p></div><div><p class=3D"MsoNormal"><u></= u>=C2=A0<u></u></p></div><div><p class=3D"MsoNormal">Is this a database tha= t has gone through upgrade stages, or a blank fresh database?<u></u><u></u>= </p></div><div><p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p></div><div><p= class=3D"MsoNormal">P<u></u><u></u></p></div></div><p class=3D"MsoNormal">= <u></u>=C2=A0<u></u></p><div><div><p class=3D"MsoNormal">On Thu, Jan 8, 202= 6 at 8:21<span style=3D"font-family:"Arial",sans-serif">=E2=80=AF= </span>AM Cedric Duprez <<a href=3D"mailto:[email protected]" target= =3D"_blank" rel=3D"noreferrer">[email protected]</a>> wrote:<u></u><u= ></u></p></div><blockquote style=3D"border:none;border-left:solid #cccccc 1= .0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in"><div><p = class=3D"MsoNormal">Hi all,<br><br>I'm facing a potential bug with Post= GIS 3.6.1 on PostgreSQL 17.7.<br>Here is what I get with postgis_full_versi= on() :=C2=A0 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=3D<a href=3D"https://cdn.proj.org" target=3D"_bl= ank" rel=3D"noreferrer">https://cdn.proj.org</a> USER_WRITABLE_DIRECTORY=3D= /tmp/proj DATABASE_PATH=3D/usr/share/proj/proj.db" (compiled against P= ROJ 9.4.0) GDAL=3D"GDAL 3.8.4, released 2024/02/08" LIBXML=3D&quo= t;2.9.14" LIBJSON=3D"0.17" LIBPROTOBUF=3D"1.4.1" W= AGYU=3D"0.5.0 (Internal)" RASTER<br><br>When I execute this query= :=C2=A0<br>SELECT 'POINT EMPTY'::public.geometry =3D 'POINT EMP= TY'::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't have this error on previous versions of Post= GIS (3.5).<br><br>How can this problem be solved?<br>Thanks in advance for = you help,<br><br>Cedric<u></u><u></u></p></div></blockquote></div></blockqu= ote></div><div><div><div><table border=3D"1" cellpadding=3D"0" style=3D"bor= der:solid #eeeded 1.0pt"><tr style=3D"height:11.25pt"><td style=3D"border:n= one;padding:.75pt .75pt .75pt .75pt;height:11.25pt"></td></tr></table><p cl= ass=3D"MsoNormal"><u></u>=C2=A0<u></u></p></div></div></div></div></div></d= iv></div></blockquote></div> --000000000000ae5b940647e36fdf--