[postgis-users] Geomunion crash

strk at refractions.net strk at refractions.net
Thu Aug 18 12:25:27 PDT 2005


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



More information about the postgis-users mailing list