[PostGIS] #5928: ST_Collect creates invalid result with only valid input
PostGIS
trac at osgeo.org
Mon Jul 28 13:41:38 PDT 2025
#5928: ST_Collect creates invalid result with only valid input
--------------------------------+---------------------------
Reporter: Lars Aksel Opsahl | Owner: pramsey
Type: defect | Status: closed
Priority: medium | Milestone: PostGIS 3.6.0
Component: postgis | Version: 3.5.x
Resolution: worksforme | Keywords:
--------------------------------+---------------------------
Comment (by Lars Aksel Opsahl):
Did you test the attached file ?
I tested now on latest released geos and postgis master
{{{
PostgreSQL 16.4 (Ubuntu 16.4-1.pgdg22.04+1) on x86_64-pc-linux-gnu,
compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit
POSTGIS="3.6.0beta1 3.6.0beta1-10-ge0e19372b" [EXTENSION] PGSQL="160"
GEOS="3.13.1-CAPI-1.19.2" PROJ="9.3.0 NETWORK_ENABLED=OFF
URL_ENDPOINT=https://cdn.proj.org USER_WRITABLE_DIRECTORY=/tmp/proj
DATABASE_PATH=/usr/local/share/proj/proj.db" (compiled against PROJ 9.3.0)
LIBXML="2.9.13" LIBJSON="0.15" LIBPROTOBUF="1.3.3" WAGYU="0.5.0
(Internal)" TOPOLOGY
}}}
Loaded attached file into the database
{{{
psql -f st_collect_error.sql
}}}
Ran the st_collect command and ST_isValid returned false
{{{
SELECT ST_IsValid(ST_Collect(org_geo)) from input_geoms where
ST_IsValid(org_geo);
NOTICE: 00000: Self-intersection at or near point 5.7186569590547141
58.939366651665459
LOCATION: pg_notice, lwgeom_pg.c:389
st_isvalid
------------
f
(1 row)
}}}
So what do I need to install to get this to work ?
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5928#comment:5>
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