[postgis-devel] [PostGIS] #1045: TopologyException if I don't use ST_Dump to resolve single geometries before I do ST_Intersection

[PostGIS]

#1045: TopologyException if I don't use  ST_Dump to resolve single geometries
before I do ST_Intersection
-------------------------+--------------------------------------------------
  Reporter:  laopsahl    |       Owner:  pramsey                                  
      Type:  defect      |      Status:  closed                                   
  Priority:  medium      |   Milestone:  PostGIS 1.5.4                            
 Component:  postgis     |     Version:  trunk                                    
Resolution:  worksforme  |    Keywords:  TopologyException ST_intersection ST_Dump
-------------------------+--------------------------------------------------
Changes (by strk):

  * status:  new => closed
  * resolution:  => worksforme


Comment:

 Works here with GEOS-3.3.2:
 {{{
  POSTGIS="2.0.0SVN" GEOS="3.3.2dev-CAPI-1.7.2" PROJ="Rel. 4.7.1, 23
 September 2009" LIBXML="2.7.6" USE_STATS

 =# SELECT
 ST_Summary(ST_Intersection(db2.non_covered,s.geo)) dekn_sats
 FROM (
 SELECT
 ST_Difference(d2.geo,db1.bestand_flate_covered) non_covered
 FROM tmp_test2.union_bestand_flate_covered db1,
 tmp_test2.dekning_omr_flate d2
 ) as db2, tmp_test2.satskog_landsdekkende_flate s
 where ST_Intersects(db2.non_covered,s.geo)
 ;
         dekn_sats
 -------------------------
  Polygon[B] with 1 rings
     ring 0 has 5 points

 (1 row)
 }}}

 What version of GEOS are you using ? Output of SELECT
 postgis_full_version().

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1045#comment:4>
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.