[postgis-tickets] [PostGIS] #5546: ERROR: operator is not unique: topogeometry <> topogeometry
PostGIS
trac at osgeo.org
Fri Sep 22 03:30:41 PDT 2023
#5546: ERROR: operator is not unique: topogeometry <> topogeometry
-----------------------+---------------------------
Reporter: strk | Owner: strk
Type: defect | Status: closed
Priority: blocker | Milestone: PostGIS 3.5.0
Component: topology | Version: master
Resolution: wontfix | Keywords: regression
-----------------------+---------------------------
Changes (by strk):
* status: assigned => closed
* resolution: => wontfix
Comment:
So the new information is that there is an implicit cast to "record", even
if not shown by the `\dC` psql command.
This means the ambiguity is between comparing the TopoGeometry objects as
if they were records or comparing them as if they were geometries. Pretty
big ambiguity and it's even a much different cost (compare as geometry is
going to be expensive).
The downstream code (pgtopo_update_sql) expected to compare as record, so
to fix the regression we would need to add TopoGeometry inequality
operator to compare the integer values of the type, but as the equality
operator (`=`) was also ambiguous in 3.0, I'd rather keep it ambiguous for
now and not consider this a regression.
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5546#comment:8>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-tickets
mailing list