[postgis-tickets] [PostGIS] #5139: PostGIS causes to_jsonb to no longer be parallel safe, ST_AsGeoJSON also parallel unsafe

[PostGIS]

#5139: PostGIS causes to_jsonb to no longer be parallel safe, ST_AsGeoJSON also
parallel unsafe
-----------------------------+---------------------------
  Reporter:  samuelspurling  |      Owner:  pramsey
      Type:  defect          |     Status:  new
  Priority:  medium          |  Milestone:  PostGIS 3.2.2
 Component:  postgis         |    Version:  3.2.x
Resolution:                  |   Keywords:
-----------------------------+---------------------------
Comment (by robe):

 I wanted to confirm that all output functions that try to output
 spatial_ref_sys metadata fail.

 I confirmed that ST_AsGML also fails.

 What is interesting is ST_AsKML doesn't.  I assume it's because it's using
 ST_Transform to convert to WGS84 long lat, but why ST_Transform doesn't
 fail when it has to also query spatial_ref_sys at some point I haven't
 quite figured out.  It looks like for the most part the projcache is used
 most of the time instead of directly calling into spatial_ref_sys, so that
 might be why.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5139#comment:6>
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.