[postgis-users] Geomunion crash

[strk at refractions.net]

On Fri, Aug 19, 2005 at 09:39:14AM +0200, strk at refractions.net wrote:
> It seems to be a precision problem again.
> If you use makepoint() instead of GeomFromText() it works fine:
> 
> SELECT Buffer(SetSRID(MakePoint(long,lat), 4269), 3) FROM bug1;

Oops... sorry, I completely skipped the geomunion part.
Still, it's precision-related. You can substitute geomunion call
with:

SELECT geomunion(SnapToGrid(geomset.geom,0.00001)) ...

The GeomFromText part doesn't hurt in this case.

--strk;

> 
> --strk;
> 
> On Thu, Aug 18, 2005 at 11:06:04PM +0000, Pierre Racine wrote:
> > SELECT postgis_full_version();
> > 
> > "POSTGIS=""1.0.3"" GEOS=""2.1.3"" PROJ=""Rel. 4.4.9, 29 Oct 2004"" 
> > USE_STATS DBPROC=""0.3.0"" RELPROC=""0.3.0"""
> > 
> > >What's the output of postgis_full_version() ?
> > >--strk;
> > 
> > >On Thu, Aug 18, 2005 at 05:04:44PM +0000, Pierre Racine wrote:
> > >>Hi,
> > >>
> > >>The following query makes geomunion(geometry set) to crash. I know there 
> > >>is two identical shapes but when I use an other parameter than "3" in 
> > >>buffer() (like 3.001), everything works fine. It also crash with "4". If 
> > >>I add "DISTINCT" in set SELECT subquery, it works fine. My understanding 
> > >>is that I should not have to...
> > >>
> > >>DROP TABLE bug1;
> > >>CREATE TABLE bug1 (lat float4,long float4);
> > >>INSERT INTO bug1 (lat,long) VALUES (45.85,-1.0667);
> > >>INSERT INTO bug1 (lat,long) VALUES (47.7,-3.333);
> > >>INSERT INTO bug1 (lat,long) VALUES (47.7,-3.333);
> > >>SELECT geomunion(geomset.geom)
> > >>  FROM (SELECT buffer(geomfromtext('POINT(' || long || ' ' || lat || ')', 
> > >>4269),3) as geom FROM bug1) as geomset;
> > >>
> > >>The result is:
> > >>
> > >>NOTICE:  TopologyException: no outgoing dirEdge found (-3.85329,44.7512)
> > >>
> > >>ERROR:  GEOS union() threw an error!
> > >>
> > >>Pierre Racine
> > >>
> > >>
> > >>_______________________________________________
> > >>postgis-users mailing list
> > >>postgis-users at postgis.refractions.net
> > >>http://postgis.refractions.net/mailman/listinfo/postgis-users
> > 
> > 
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users