id summary reporter owner description type status priority milestone component version resolution keywords cc 3146 ST_EffectiveArea possible 32-bit crasher robe pramsey "Doing garden crash test on my 32-bit PostgreSQL 9.4 EDB, this crashes {{{ SELECT ST_SetEffectiveArea(foo1.the_geom, 20.1, 5) As result FROM ((SELECT ST_GeomFromText('LINESTRING(1 2, 1 2)',4326) As the_geom UNION ALL SELECT ST_MakeLine('SRID=4326;POINT(1 2)'::geometry, 'SRID=4326;POINT EMPTY'::geometry) As the_geom ) ) As foo1 LIMIT 3; }}} It might just be a 32-bit crasher on my 9.5 instance works okay, but I haven't tested against 64-bit 9.4 EDB install to be sure it's not a VC/mingw64 thing. My 64-bit install is also a bit older. This I tested under: {{{ POSTGIS=""2.2.0dev r13601"" GEOS=""3.5.0dev-CAPI-1.9.0 r4054"" PROJ=""Rel. 4.8.0, 6 March 2012"" GDAL=""GDAL 1.11.1, released 2014/09/24"" LIBXML=""2.7.8"" LIBJSON=""0.12"" RASTER;PostgreSQL 9.4.2, compiled by Visual C++ build 1800, 32-bit }}} " defect closed blocker PostGIS 2.2.0 postgis master fixed