[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