[postgis-tickets] [PostGIS] #5181: Invalid PROJ string in ST_Transform breaks subsequent queries

[PostGIS]

#5181: Invalid PROJ string in ST_Transform breaks subsequent queries
-----------------------+-------------------------------
  Reporter:  kszafran  |      Owner:  pramsey
      Type:  defect    |     Status:  new
  Priority:  medium    |  Milestone:  PostGIS 3.1.7
 Component:  postgis   |    Version:  3.1.x
Resolution:            |   Keywords:  st_transform proj
-----------------------+-------------------------------
Changes (by robe):

 * version:  3.2.x => 3.1.x
 * milestone:  PostGIS 3.2.2 => PostGIS 3.1.7

Comment:

 I've pushed this back one micro, sadly too late for this release.

 I confirm, I get the same error on:


 {{{
 POSTGIS="3.2.0 3.2.0" [EXTENSION] PGSQL="130" GEOS="3.10.1-CAPI-1.16.0"
 SFCGAL="1.4.0" PROJ="7.2.1" GDAL="GDAL 3.3.3, released 2021/10/25"
 LIBXML="2.9.9" LIBJSON="0.12" LIBPROTOBUF="1.2.1" WAGYU="0.5.0 (Internal)"
 TOPOLOGY RASTER PostgreSQL 13.4, compiled by Visual C++ build 1914, 64-bit
 }}}


 when doing this:


 {{{
 SELECT ST_Transform(ST_SetSRID(ST_MakePoint(1, 2), 4326), '+wat');
 -- could not parse proj string '+wat'

 then following with:

 SELECT ST_Transform(ST_SetSRID(ST_MakePoint(1, 2), 4326), 3875);
 -- get error ERROR:  transform: generic error of unknown origin (-61)
 }}}

 So I suspect it's our proj caching layer at fault here and it's probably
 caching something from the bad transform which is screwing it up.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5181#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.