Re: PostGIS 3.6.1 - ERROR: operator is not unique: public.geometry = public.geometry
Cedric Duprez <[email protected]> Thu, 8 Jan 2026 17:52:33 +0100
| Newsgroups | gmane.comp.gis.postgis |
|---|---|
| Message-ID | <[email protected]> |
--------------TAJp0Y2iu5h0BW9N3djtd93N Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Hi Paul, Thanks for your answer. The database was restored from a cold physical backup (PGDATA copy). Cedric Le 08/01/2026 à 17:25, Paul Ramsey a écrit : > This is odd, I am not able to replicate... > > -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- > POSTGIS="3.6.1dev 3.6.0-6-gdb18a9a49" PGSQL="180" > GEOS="3.15.0dev-CAPI-1.21.0" PROJ="9.3.0 NETWORK_ENABLED=ON > URL_ENDPOINT=https://cdn.proj.org > USER_WRITABLE_DIRECTORY=/Users/pramsey/Library/Application > Support/proj DATABASE_PATH=/usr/local/share/proj/proj.db" (compiled > against PROJ 9.3.0) LIBXML="2.9.13" LIBJSON="0.17" LIBPROTOBUF="1.4.1" > WAGYU="0.5.0 (Internal)" > (1 row) > > postgis_reg=# SELECT 'POINT EMPTY'::public.geometry = '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 AM 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="3.6.1 > f533623" [EXTENSION] PGSQL="170" GEOS="3.12.1-CAPI-1.18.1" > PROJ="9.4.0 NETWORK_ENABLED=OFF URL_ENDPOINT=https://cdn.proj.org > USER_WRITABLE_DIRECTORY=/tmp/proj > DATABASE_PATH=/usr/share/proj/proj.db" (compiled against PROJ > 9.4.0) GDAL="GDAL 3.8.4, released 2024/02/08" LIBXML="2.9.14" > LIBJSON="0.17" LIBPROTOBUF="1.4.1" WAGYU="0.5.0 (Internal)" RASTER > > When I execute this query: > SELECT 'POINT EMPTY'::public.geometry = 'POINT > EMPTY'::public.geometry; > I get the following error: > ERROR: operator is not unique: public.geometry = 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 > --------------TAJp0Y2iu5h0BW9N3djtd93N Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit <!DOCTYPE html><html><head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> </head> <body> <font face="Helvetica, Arial, sans-serif">Hi Paul,<br> <br> Thanks for your answer.<br> The database was restored from a cold physical backup (PGDATA copy).<br> <br> Cedric<br> </font><br> <div class="moz-cite-prefix">Le 08/01/2026 à 17:25, Paul Ramsey a écrit :<br> </div> <blockquote type="cite" cite="mid:CACowWR1rTX7t=+KOKer5Dc+CyRKOacv5xwMVt_Ef1spWSeFZfw@mail.gmail.com"> <div dir="ltr">This is odd, I am not able to replicate... <div><br> </div> <div>--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br> POSTGIS="3.6.1dev 3.6.0-6-gdb18a9a49" PGSQL="180" GEOS="3.15.0dev-CAPI-1.21.0" PROJ="9.3.0 NETWORK_ENABLED=ON URL_ENDPOINT=<a href="https://cdn.proj.org" moz-do-not-send="true" class="moz-txt-link-freetext">https://cdn.proj.org</a> USER_WRITABLE_DIRECTORY=/Users/pramsey/Library/Application Support/proj DATABASE_PATH=/usr/local/share/proj/proj.db" (compiled against PROJ 9.3.0) LIBXML="2.9.13" LIBJSON="0.17" LIBPROTOBUF="1.4.1" WAGYU="0.5.0 (Internal)"<br> (1 row)<br> <br> postgis_reg=# SELECT 'POINT EMPTY'::public.geometry = 'POINT EMPTY'::public.geometry;<br> ?column? <br> ----------<br> 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="gmail_quote gmail_quote_container"> <div dir="ltr" class="gmail_attr">On Thu, Jan 8, 2026 at 8:21 AM Cedric Duprez <<a href="mailto:[email protected]" moz-do-not-send="true" class="moz-txt-link-freetext">[email protected]</a>> wrote:<br> </div> <blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"> <div> Hi all,<br> <br> I'm facing a potential bug with PostGIS 3.6.1 on PostgreSQL 17.7.<br> Here is what I get with postgis_full_version() : POSTGIS="3.6.1 f533623" [EXTENSION] PGSQL="170" GEOS="3.12.1-CAPI-1.18.1" PROJ="9.4.0 NETWORK_ENABLED=OFF URL_ENDPOINT=<a href="https://cdn.proj.org" target="_blank" moz-do-not-send="true" class="moz-txt-link-freetext">https://cdn.proj.org</a> USER_WRITABLE_DIRECTORY=/tmp/proj DATABASE_PATH=/usr/share/proj/proj.db" (compiled against PROJ 9.4.0) GDAL="GDAL 3.8.4, released 2024/02/08" LIBXML="2.9.14" LIBJSON="0.17" LIBPROTOBUF="1.4.1" WAGYU="0.5.0 (Internal)" RASTER<br> <br> When I execute this query: <br> SELECT 'POINT EMPTY'::public.geometry = 'POINT EMPTY'::public.geometry;<br> I get the following error:<br> ERROR: operator is not unique: public.geometry = 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> <br> <div id="grammalecte_menu_main_button_shadow_host" style="width: 0px; height: 0px;"></div> </body> </html> --------------TAJp0Y2iu5h0BW9N3djtd93N--