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
