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

PostGIS trac at osgeo.org
Mon Apr 16 02:31:17 PDT 2012

#1252: SRID appearing in ST_AsText for particular multipolygon
 Reporter:  robe             |       Owner:  pramsey      
     Type:  defect           |      Status:  new          
 Priority:  medium           |   Milestone:  PostGIS 1.5.4
Component:  postgis          |     Version:  1.5.X        
 Keywords:  windows, 64-bit  |  
Changes (by ipackham):

 * cc: ipackham (added)


 I have also seen this problem on my 64-bit Windows machine (running
 PostGis for 32-bit). The resulting geometries of an ST_Union has a
 misplaced SRID. This crashes QGIS when it tries to load from the table. If
 I backup the table and restore it, the strange SRID is gone, so PostGIS
 seems to be able to fix it, but QGIS can't. Also look similar to a problem
 in QGIS mentioned a while ago:


 I can supply a dump of my geometries that, after running an ST_Union
 creates the weird geometries, let me know if (how?) you want these.
 I see a work around above using bytea, which I will try, but would like to
 know if this fix will be in v1.5.4 or is it already fixed in v2.0 for

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