[postgis-tickets] [PostGIS] #4894: Intersection with distinct geometries crashes postgres

[PostGIS]

#4894: Intersection with distinct geometries crashes postgres
----------------------+---------------------------
  Reporter:  mschott  |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 3.1.2
 Component:  postgis  |    Version:  3.1.x
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by mdavis):

 This is caused by a GEOS 3.8 issue (see
 [https://trac.osgeo.org/geos/ticket/1047 GEOS-1047]).  This is fixed in
 the 3.8 branch, but not yet released.  A release of GEOS 3.8.2 is
 underway.

 In the meantime, a workaround is to convert the single-element
 `GEOMETRYCOLLECTION/MULTIPOLYGON` to a `POLYGON`.  This can be done using
 [https://postgis.net/docs/ST_CollectionHomogenize.html
 ST_CollectionHomogenize].

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4894#comment:1>
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.