Re: PostGIS 3.6.1 - ERROR: operator is not unique: public.geometry = public.geometry
Arthur Bazin <[email protected]> Thu, 8 Jan 2026 17:54:46 +0100
| Newsgroups | gmane.comp.gis.postgis |
|---|---|
| Message-ID | <CABjE6y3PNV4R_7CsOGHEyHkbn5-NomvhNACX0tvL8FsdSsemDw@mail.gmail.com> |
--000000000000d146cd0647e34496 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable @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 f5336= 23" >> [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 >> > --000000000000d146cd0647e34496 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <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</div><div dir=3D"auto">Arth= ur</div><div dir=3D"auto"><br></div><div dir=3D"auto"><br></div></div><br><= div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">Le jeu. 8 j= anv. 2026, 17:26, Paul Ramsey via postgis-users <<a href=3D"mailto:postg= [email protected]" target=3D"_blank" rel=3D"noreferrer">postgis-user= [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 dir=3D"ltr">This is odd, I am not able to replicate...<div>= <br></div><div>------------------------------------------------------------= ---------------------------------------------------------------------------= ---------------------------------------------------------------------------= ---------------------------------------------------------------------------= ---------------------------------------------------------------------------= --------<br>=C2=A0POSTGIS=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_ENDPOINT=3D<a href=3D"https://cdn.proj.org" re= l=3D"noreferrer noreferrer" target=3D"_blank">https://cdn.proj.org</a> USER= _WRITABLE_DIRECTORY=3D/Users/pramsey/Library/Application Support/proj DATAB= ASE_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&quo= t;1.4.1" WAGYU=3D"0.5.0 (Internal)"<br>(1 row)<br><br>postgi= s_reg=3D# SELECT 'POINT EMPTY'::public.geometry =3D 'POINT EMPT= Y'::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 database that ha= s gone through upgrade stages, or a blank fresh database?</div><div><br></d= iv><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 <<a= href=3D"mailto:[email protected]" rel=3D"noreferrer noreferrer" target= =3D"_blank">[email protected]</a>> wrote:<br></div><blockquote class= =3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;bo= rder-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">= <u></u> =20 <div> Hi all,<br> <br> I'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"= 3.6.1 f533623" [EXTENSION] PGSQL=3D"170" GEOS=3D"3.12.1-C= API-1.18.1" PROJ=3D"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" (compiled against PROJ 9.= 4.0) GDAL=3D"GDAL 3.8.4, released 2024/02/08" LIBXML=3D"2.9.1= 4" LIBJSON=3D"0.17" LIBPROTOBUF=3D"1.4.1" WAGYU=3D&quo= t;0.5.0 (Internal)" RASTER<br> <br> When I execute this query:=C2=A0<br> SELECT 'POINT EMPTY'::public.geometry =3D 'POINT EMPTY'::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 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 data-smartmail= =3D"gmail_signature"><div dir=3D"ltr"><div dir=3D"ltr"><table style=3D"font= -family:trebuchet ms,tahoma,sans-serif;font-size:11px;line-height:11px;colo= r:rgb(76,0,151);margin:10px 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> --000000000000d146cd0647e34496--