[postgis-users] Geomunion crash

[Pierre Racine]

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