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

[Sandro Santilli]

On Sat, Nov 05, 2011 at 03:48:03PM -0400, Paragon Corporation wrote:
>  
> 
> > > Comment(by robe):
> > > 
> > >  strk - FYI - just retired again on  a1.5.3 database running the 
> > > latest  3.3.2dev and I still get the same weird behavior.  
> > Now I fear 
> > > it might be  a windows only bug.
> > > 
> > >  Do you have a 1.5 install?  I haven't compiled 1.5.4svn to 
> > see if the  
> > > problem is still there I'll try to do that later.
> > > 
> > >  Make sure you are testing with the script I attached to this ticket
> > > 
> > >  http://trac.osgeo.org/postgis/attachment/ticket/1252/weird_poly.sql
> > 
> > Robe, are you saying you can reproduce the bug with the 
> > attached script ?
> > I surely can't, and I'm surprised you can.
> > I'm testing with 1.5 branch.
> 
> Yes that is exactly what I am saying.  On a different box from the one I
> noticed the problem.
> Both are windows boxes 64-bit running 32-bit PostGIS however.  On my local
> 64-bit Windows 7 desktop
> and a 64-bit Windows 2008 cloud server. 
> 
> Both runnint PostGIS 1.5.3, PostgreSQL 9.0 (I can reporduce on my 9.1
> instance too running 1.5.3). I haven't had a chance to test on 1.5.4 branch
> yet though
> so I'll compile that and see if maybe the problem goes away.
> 
> I'll also try to run on a 1.5.2 (as I recall the server I had that didn't
> exhibit this problem was running 3.3.0, PostGIS 1.5.2 and 32-bit Windows
> 2003)
> but I'll verify on my desktop to rule out a change in 1.5.3 as the culprit.
> 
> Strk -- so you are saying that when you run:
> SELECT ST_AsText(ST_Union(geom))
> FROM (SELECT (ST_Dump(geom)).geom
> FROM weird_mpoly) As foo ;

 MULTIPOLYGON(((-116.9937666 33.4711291 ...

 POSTGIS="1.5.4SVN" GEOS="3.3.0-CAPI-1.7.0" PROJ="Rel. 4.7.1, 23 September 2009" LIBXML="2.7.6" USE_STATS

32bit GNU/Linux with 32bit PostGIS.

--strk; 

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html