Thanks a lot, this seems to work fine as a workaround. Anyone know if this exact problem persists in current versions of postgis (could be an incentive to upgrade)?
Christophe -----Oorspronkelijk bericht----- Van: [email protected] [mailto:[email protected]] Namens Kevin Neufeld Verzonden: woensdag 9 december 2009 18:26 Aan: PostGIS Users Discussion Onderwerp: Re: [postgis-users] invalid geometry crashes postgres when trying to use buffer Try reducing the precision of your geometry. PostGIS doesn't actually have a precision reducer function yet, but ST_SnapToGrid comes close. -- Kevin Christophe Diericx wrote: > Hello everyone, > > Issuing the following query (while trying to repair an invalid > geometry): > > ** select buffer(ST_GeomFromText('mypoly',32767),0) > > crashes postgresql hard (extract from the postgresql error-log here: > http://paste.pocoo.org/show/155923/). > > 'mypoly' can be seen here: http://paste.pocoo.org/show/155921/. > > 32767 corresponds to the following proj4 string: "+proj=lcc > +lat_1=49.8333333333 +lat_2=51.1666666667 +lat_0=90 > ++lon_0=4.3569397222 > +x_0=150000.01256 +y_0=5400088.4378 +ellps=intl > +towgs84=81,120,129,0,0,0,0 +units=m +no_defs" > > Some more information about my setup: > > -- select postgis_full_version() > "POSTGIS="1.3.5" GEOS="3.1.0-CAPI-1.5.0" PROJ="Rel. 4.6.0, 21 Dec 2007" > USE_STATS" > -- select version() > "PostgreSQL 8.3.7 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.2.4 > (Ubuntu 4.2.4-1ubuntu3)" > > Is this a known issue and is this fixed in later builds? > > Does anyone have an idea for a workaround with my current versions? > > Thanks in advance for all reactions! > > Christophe > _______________________________________________ > 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 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
