[postgis-devel] [PostGIS] #1252: SRID appearing in ST_AsText for particular multipolygon

PostGIS trac at osgeo.org
Wed Oct 26 17:52:19 PDT 2011

#1252: SRID appearing in ST_AsText for particular multipolygon
 Reporter:  robe     |       Owner:  pramsey       
     Type:  defect   |      Status:  new           
 Priority:  medium   |   Milestone:  PostGIS Future
Component:  postgis  |     Version:  1.5.X         
 Keywords:           |  

Comment(by robe):

 ahah -- I was able to remutate it outside of my database by running these.
 So not sure if the issue is with ST_Dump or ST_Union except it seems to be
 fine in my PostGIS 2.0 database, but spits out this thing in my 1.5.  Both
 are running GEOS 3.3.1

 See attached table and query
 -- no weirdness --
 SELECT ST_AsText(geom) from weird_mpoly;

 --it mutates into something scary --

 SELECT ST_AsText(ST_Union(geom))
 FROM (SELECT (ST_Dump(geom)).geom
 FROM weird_mpoly) As foo ;

 Strk -- remember that problem I was talking about and how it crashed my
 server and I couldn't figure out which set of data I was processing.  I
 wonder if something like this was happening.  This geometry is generated
 from the same process that caused the crashing I mentioned in ticket.


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

More information about the postgis-devel mailing list