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

[PostGIS]

#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 pramsey):

 Does this occur on PgSQL 14? I'm trying to replicate and failing.
 {{{
 =# explain with objs as (select id, fcname, to_jsonb(geom) from
 large_table) select * into temporary table large_table_tmp from objs where
 id > 990000;

                                     QUERY PLAN
 -----------------------------------------------------------------------------------
  Gather  (cost=1000.00..76996.72 rows=42582 width=41)
    Workers Planned: 2
    ->  Parallel Seq Scan on large_table  (cost=0.00..71738.52 rows=17742
 width=41)
          Filter: (id > 990000)
 (4 rows)


 =# with objs as (select id, fcname, to_jsonb((large_table.geom)) from
 large_table) select * into temporary table large_table_tmp from objs where
 id > 990000;

 SELECT 40000

 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5139#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.