Changes between Version 1 and Version 3 of Ticket #5830


Ignore:
Timestamp:
01/06/25 01:52:18 (2 days ago)
Author:
hhinrichs
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #5830

    • Property Keywords st_equals added

  • Ticket #5830 – Description

    v1 v3  
    55
    66Dummy query that fails:
     7
    78SELECT 1 FROM communities c1, communities c2 WHERE ST_Equals(c1.geom, c2.geom)
    89
    910Dummy query that runs:
    10 SELECT 1 FROM communities c1, communities c2 WHERE ST_Equals(c1.geom, c2.geom) AND c1.gisco_code = 'DE_01001000'
     11
     12SELECT 1 FROM communities c1, communities c2 WHERE ST_Equals(c1.geom, c2.geom) AND ST_Intersects(c1.geom, c2.geom)
     13
     14What also works is
     15
     16SELECT 1 FROM communities c1, communities c2 WHERE ST_Within(c1.geom, c2.geom)
    1117
    1218The error my postgres container logs:
    … …  
    1521I tried to run the failing query on our staging environment where we have PostGis 3.4.0 and it runs without any error.
    1622
    17 I was unable to install 3.4.x locally as older versions seem to get deleted from the apt repository and installing it from source was pain and did not work in the end.
     23I was unable to install 3.4.x locally as older versions seem to get deleted from the apt repository and installing from source I was unable to Installing it from s.
    1824
    1925EDIT: I wanted to attach the data but it exceeds the size limit.