[postgis-devel] Postgres dies on ST_MakeValid

Fri Mar 30 09:01:50 PDT 2018

this works for me:

dbb=# select st_MakeValid(ST_GeomFromWKB('010200000011000000b20X9 
}366 at 7211A340235I34A316326t18}366 at 306g347323230I34Ay351&18}366 at 331316367323230I34A372~j274370}366 at 315314314LpI34A343245233304R}366 at R2703605?I34A315314314314Z~366 at 34324523330407I34A04V16-242}366 at 252361322M323H34A351&110306{366 at H341z247I34Ab20X9 
}366 at 7211A340235I34A'));

          st_makevalid                             

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 01020000000900000062105839207DF640378941E09D491C41CED67431387DF640C667E7D398491C4179E92631387DF640D9CEF7D398491C41FA7E6ABCF87DF640CDCCCC4C70491C41E3A59BC4527DF64052B81E053F491C41CDCCCCCC5A7EF640E3A59BC407491C4104560E2DA27DF640AAF1D24DD3481C41E9263108C67BF64048E17A1437491C4162105839207DF640378941E09D491C41

 POSTGIS="2.4.3" PGSQL="100" GEOS="3.6.2-CAPI-1.10.2 4d2925d6" 
SFCGAL="1.3.0" PROJ="Rel. 4.9.3, 15 August 2016" LIBXML="2.9.3" 
LIBJSON="0.11.99" LIBPROTOBUF="1.2.1" (core procs from "2.4.3" need 
upgrade) (sfcgal procs from "2.4.3" need upgrade)

--------------------------------------------------------------------------------------------------
On Fri, 30 Mar 2018 16:39:18 0200, Tom van Tilburg 
<tom.van.tilburg at gmail.com> wrote:

Postgres says:
"...pure virtual method called
terminate called without an active exception ..."
before dying

Fresh postgis build:
"POSTGIS="2.5.0dev r16508" [EXTENSION] PGSQL="100" 
GEOS="3.6.2-CAPI-1.10.2 4d2925d6" SFCGAL="1.3.1" PROJ="Rel. 4.9.3, 15 
August 2016" GDAL="GDAL 2.2.3, released 2017/11/20" LIBXML="2.9.4" 
LIBJSON="0.12.1" LIBPROTOBUF="1.2.1" RASTER (sfcgal procs from "2.5.0 
(...)"

I can only reproduce when outputting the binary geometry, WKT doesn't 
give this problem:

SELECT 
ST_MakeValid(ST_MakePolygon(ST_GeomFromWKB('010200000011000000b20X9 
}366 at 7211A340235I34A316326t18}366 at 306g347323230I34Ay351&18}366 at 331316367323230I34A372~j274370}366 at 315314314LpI34A343245233304R}366 at R2703605?I34A315314314314Z~366 at 34324523330407I34A04V16-242}366 at 252361322M323H34A351&110306{366 at H341z247I34Ab20X9 
}366 at 7211A340235I34A')))

Output of ST_Isvalidreason gives "Self-intersection[92115.5120743143 
463462.206937431]"

Best,
 Tom

-------------------------

_______________________________________________
postgis-devel mailing list
postgis-devel at lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-devel

--
Brian M Hamlin
OSGeo California
blog.light42.com