Hi Rolf, We don't believe in known limitations, we believe in fixing them :) If you can zip up the offending geometry and I can replicate the crash we'll fix it in the next release.
create table badgeom as select * from mytable where gid = 'the gid of hte bad geom'; pg_dump -t badgeom mydatabase > dump.sql bzip2 dump.sql Then attach that dump file to a fresh ticket in trac http://trac.osgeo.org/postgis Thanks, P On Fri, Dec 4, 2009 at 3:31 AM, Rolf de By <[email protected]> wrote: > All, > > Working my way through a large batch of externally obtained polygon data, > and attempting to repair topo errors like ring self-intersections, I ran > into a server crash with the following query: > > select *, st_isvalidreason(st_makepolygon(geom)) > from tempgeo > > tempgeo holds rings from original polygons as linestrings. This query has > worked me through 75% of the errrors, but crashes now on one. > I have discovered that the linestring on which this happens is just over > 64,000 points. Is this a known limitation? > > I am running on a PG 8.4.1 on a Windows Vista box, > postgis_full_version="POSTGIS="1.4.0" GEOS="3.1.1-CAPI-1.6.0" PROJ="Rel. > 4.6.1, 21 August 2008" USE_STATS" > > regards, > > Rolf > > International Institute for Geo-Information Science and Earth Observation > (ITC) > Chamber of Commerce: 410 27 560 > > E-mail disclaimer > The information in this e-mail, including any attachments, is intended for > the addressee only. If you are not the intended recipient, you are hereby > notified that any disclosure, copying, distribution or action in relation to > the content of this information is strictly prohibited. If you have received > this e-mail by mistake, please delete the message and any attachment and > inform the sender by return e-mail. ITC accepts no liability for any error > or omission in the message content or for damage of any kind that may arise > as a result of e-mail transmission. > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
