[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:  high     |  Milestone:  PostGIS 3.1.0
 Component:  postgis  |    Version:  master
Resolution:           |   Keywords:
----------------------+---------------------------
Changes (by robe):

 * priority:  medium => high


Comment:

 Okay the good news is after I put in the PROJ_LIB env variable and
 restarted the service.

 I get this:


 {{{
 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" LIBXML="2.9.9" LIBJSON="0.12" LIBPROTOBUF="1.2.1"
 WAGYU="0.5.0 (Internal)" TOPOLOGY RASTER
 }}}

 and it works:


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

 }}}

 outputs

 {{{
 POINT Z (-100.00041762022582 40.00000948365179 30.480060960121918)
 }}}

 Still a bit scary though that it crashes the server when it can't find the
 grid files

 Note this is related to #4766  but scary that in order to see something is
 wrong, I have to have raster installed.  We need better checking of proj
 in PostGIS proper and also for it not to crash if it can't find files.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4792#comment:1>
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.