[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
-----------------------+-------------------------------
Comment (by robe):

 I still get the error on 3.2.2 released and 3.2.3dev
 . I don't get it running pramsey's example though.

 Seems you have to do all 3 to trigger the issue.  If you leave out the
 first query the problem doesn't happen.  It's almost as if the system
 first caches the answer of 3875 on first run.  The error pollutes that
 cache, and the 3rd tries to use the polluted cache.  without that first
 run seems the system thinks it a fresh request so doesn't attempt to use
 cache.


 {{{
 SELECT ST_Transform(ST_SetSRID(ST_MakePoint(1, 2), 4326), 3875);

 SELECT ST_Transform(ST_SetSRID(ST_MakePoint(1, 2), 4326), '+wat');

 SELECT ST_Transform(ST_SetSRID(ST_MakePoint(1, 2), 4326), 3875);
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5181#comment:4>
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.