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

PostGIS trac at osgeo.org
Thu Jul 21 21:47:11 PDT 2022


#5139: PostGIS causes to_jsonb to no longer be parallel safe
-----------------------------+---------------------------
  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):

 As I recall I think perhaps in 3.1 we didn't do a call to spatial_ref_sys
 to look up the auth and srid.  I think we just hard-coded EPSG:<srid>  of
 the geometry.  So that change to look it up, cause "the auth could be
 different", probably triggered this issue.  I'm not sure there is a fix
 short of going back to the way we used to do it.  We could probably at
 least hard-code the 4326 case.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5139#comment:3>
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.


More information about the postgis-tickets mailing list