[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