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

[PostGIS]

#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)


Comment:

 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:

 http://postgis.refractions.net/pipermail/postgis-
 users/2008-October/021750.html

 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
 Windows?

-- 
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.