[postgis-users] Geomunion crash

[strk at refractions.net]

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;

--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