[postgis-tickets] [PostGIS] #4792: ST_Transform crashes server (windows)

[PostGIS]

#4792: ST_Transform crashes server (windows)
---------------------+---------------------------
 Reporter:  robe     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:  PostGIS 3.1.0
Component:  postgis  |    Version:  master
 Keywords:           |
---------------------+---------------------------
 This might be just a windows or my misconfigured PROJ.

 I pulled this example from pramsey's blog


 {{{
 SELECT ST_Astext(
          ST_Transform(
            ST_SetSRID(geometry('POINT(-100 40 100)'),7406),
            5500));

 }}}

 http://blog.cleverelephant.ca/2019/02/proj4-postgis.html

 On PostGIS 3.0 with Proj 5.2 (POSTGIS="3.0.2 3.0.2" [EXTENSION]
 PGSQL="120" GEOS="3.8.1-CAPI-1.13.3" SFCGAL="1.3.8" PROJ="Rel. 5.2.0,
 September 15th, 2018" LIBXML="2.9.9" LIBJSON="0.12" LIBPROTOBUF="1.2.1"
 WAGYU="0.4.3 (Internal)")
 , doesn't work at all which is expected:


 {{{
 NOTICE:  PostGIS was unable to transform the point because either no grid
 shift files were found, or the point does not lie within the range for
 which the grid shift is defined. Refer to the ST_Transform() section of
 the PostGIS manual for details on how to configure PostGIS to alter this
 behaviour.

 ERROR:  transform: couldn't project point (-100 40 100): failed to load
 datum shift file (-38)
 SQL state: XX000
 }}}

 But on PostGIS 3.1.0 ( PostgreSQL 13.1, compiled by Visual C++ build 1914,
 64-bit POSTGIS="3.1.0dev 3.1.0alpha2-157-gdfeaaac70" [EXTENSION]
 PGSQL="130" GEOS="3.9.0-CAPI-1.14.0" SFCGAL="1.3.8" PROJ="6.3.2"
 GDAL="GDAL 3.2.0, released 2020/10/26 GDAL_DATA not found" LIBXML="2.9.9"
 LIBJSON="0.12" LIBPROTOBUF="1.2.1" WAGYU="0.5.0 (Internal)" TOPOLOGY
 RASTER)

 It just crashes.

 I'll do a gdb check next to see where it is crashing.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4792>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.