[postgis-devel] Issue 119 in postgis: ST_AsSVG crashedDBbackendwith large geometries.

Obe, Regina robe.dnd at cityofboston.gov
Mon Mar 9 21:30:05 PDT 2009


Olivier,

I retested on my same box (blowing out my whole svn and redownloading from scratch and still run into the same issues.).  I'll be able to test on windows aond my other OpenSUSe tomorrow.

Anyrate I am running
"POSTGIS="1.4.0SVN" GEOS="3.1.0-CAPI-1.5.0" PROJ="Rel. 4.6.0, 21 Dec 2007" USE_STATS"  (also verifeid it was built minutes ago)

"PostgreSQL 8.3.1 on i686-pc-linux-gnu, compiled by GCC gcc (SUSE Linux) 4.3.1 20080507 (prerelease) [gcc-4_3-branch revision 135036]"

I wonder if its my gcc or something that is the culprit.  Below is list of things that works and what crashes. Seems to crash when it gets to polygons. If others could test on their platforms that would be super.

--Point works.
 SELECT ST_AsSVG(foo1.the_geom)

                        FROM ((SELECT ST_SetSRID(ST_Point(i,j),4326) As the_geom
                FROM generate_series(-10,50,15) As i
                        CROSS JOIN generate_series(40,70, 15) j)) As foo1;

--lines work
        SELECT ST_AsSVG(foo1.the_geom)

                        FROM ((SELECT ST_MakeLine(ST_SetSRID(ST_Point(i,j),4326),ST_SetSRID(ST_Point(j,i),4326))  As the_geom
                FROM generate_series(-10,50,10) As i
                        CROSS JOIN generate_series(40,70, 15) As j
                        WHERE NOT(i = j))) As foo1;


--polygon crashes server
        SELECT ST_AsSVG(foo1.the_geom)

                        FROM ((SELECT ST_Buffer(ST_SetSRID(ST_Point(i,j),4326), j)  As the_geom
                FROM generate_series(-10,50,10) As i
                        CROSS JOIN generate_series(40,70, 20) As j)) As foo1;




-----Original Message-----
From: postgis-devel-bounces at postgis.refractions.net on behalf of Courtin Olivier
Sent: Mon 3/9/2009 5:09 PM
To: PostGIS Development Discussion
Subject: Re: [postgis-devel] Issue 119 in postgis: ST_AsSVG crashedDBbackendwith large geometries.
 

On Mar 9, 2009, at 5:00 PM, Obe, Regina wrote:

Regina,
> I was using OpenSUSE 11 with GEOS 3.1, but I presume the geos  
> doesn't matter for svg.
>
Indeed, no GEOS operation at all,
> I'll double-check to make sure I did install and so forth -- could  
> be something wrong with my install.  I'll also try on another pc  
> tomorrow.
>
Ok, let will see...
on my own:

  POSTGIS="1.4.0SVN" GEOS="3.0.2-CAPI-1.4.2" PROJ="Rel. 4.6.1, 21  
August 2008" USE_STATS
  Linux Slackware 12.1
  postgis r 3819
  => Ok on the whole garden test


POSTGIS="1.4.0SVN" GEOS="3.1.0-CAPI-1.5.0" PROJ="Rel. 4.6.0, 21 Dec  
2007" USE_STATS
Mac Os.X 10.5
postgis r 3817
  => Ok on the whole garden test

--
Olivier
_______________________________________________
postgis-devel mailing list
postgis-devel at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-devel



-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20090310/4c5916ad/attachment.html>


More information about the postgis-devel mailing list