[postgis-users] Geomunion crash

Pierre Racine racine_pierre at hotmail.com
Thu Aug 18 10:04:44 PDT 2005


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





More information about the postgis-users mailing list