Opened 6 years ago

Last modified 6 years ago

#3952 closed defect

ST_Transform fails in parallel mode — at Version 1

Reported by: pramsey Owned by: pramsey
Priority: blocker Milestone: PostGIS 2.4.4
Component: postgis Version: 2.4.x
Keywords: Cc:

Description (last modified by pramsey)

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.

Change History (1)

comment:1 by pramsey, 6 years ago

Description: modified (diff)
Note: See TracTickets for help on using tickets.