[postgis-users] st_isvalidreason crashes server

[Paul Ramsey]

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 <deby at itc.nl> 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>