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

[PostGIS]

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

 * milestone:  PostGIS 3.2.2 => PostGIS 3.1.7

Comment:

 I'm pushing this to PostGIS 3.1. Even though the issue here manifests
 because of the auto-cast in to_jsonb, to now do proper casting of postgis
 geometry (instead of just returning the canonical hex),  the underlying
 issue is the ST_AsGeoJSON, ST_AsGML and their call of the spatial_ref_sys
 table.  Perhaps if we switched those to using cached values like
 ST_Transform, that might fix the issue or at least make it less common.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5139#comment:8>
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.