[postgis-users] st_isvalidreason crashes server

Rolf de By deby at itc.nl
Fri Dec 4 03:31:02 PST 2009


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.



More information about the postgis-users mailing list