[postgis-tickets] [PostGIS] #3952: ST_Transform fails in parallel mode

[PostGIS]

#3952: ST_Transform fails in parallel mode
----------------------+---------------------------
  Reporter:  pramsey  |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 2.4.3
 Component:  postgis  |    Version:  2.4.x
Resolution:           |   Keywords:
----------------------+---------------------------
Description changed by pramsey:

Old description:

> From an example query:
> ```
> ebc_13_17=# create table db_2011 as select st_transform(g.geom,3005) as
> geom, g.dbuid, a.dbpop2011, a.dbtdwell2011, a.dburdwell2011 from
> db_attr_2011 a join db_gis_2011 g using (dbuid) where g.pruid = '59' ;
> ERROR:  cannot start commands during a parallel operation
> CONTEXT:  SQL statement "SELECT proj4text FROM spatial_ref_sys WHERE srid
> = 4326 LIMIT 1"
> ```
> Looks like the underlying proj lookup using SPI is not happy w/ the
> parallel executor.

New description:

 From an example query:
 {{{
 ebc_13_17=# create table db_2011 as
   select st_transform(g.geom,3005) as geom, g.dbuid, a.dbpop2011,
 a.dbtdwell2011, a.dburdwell2011
   from db_attr_2011 a join db_gis_2011 g
   using (dbuid) where g.pruid = '59' ;

 ERROR:  cannot start commands during a parallel operation
 CONTEXT:  SQL statement "SELECT proj4text FROM spatial_ref_sys WHERE srid
 = 4326 LIMIT 1"
 }}}
 Looks like the underlying proj lookup using SPI is not happy w/ the
 parallel executor.

--

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