Changes between Initial Version and Version 1 of Ticket #3952


Ignore:
Timestamp:
Dec 23, 2017, 3:50:06 PM (6 years ago)
Author:
pramsey
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #3952 – Description

    initial v1  
    11From an example query:
    2 ```
    3 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' ;
     2{{{
     3ebc_13_17=# create table db_2011 as
     4  select st_transform(g.geom,3005) as geom, g.dbuid, a.dbpop2011, a.dbtdwell2011, a.dburdwell2011
     5  from db_attr_2011 a join db_gis_2011 g
     6  using (dbuid) where g.pruid = '59' ;
     7
    48ERROR:  cannot start commands during a parallel operation
    59CONTEXT:  SQL statement "SELECT proj4text FROM spatial_ref_sys WHERE srid = 4326 LIMIT 1"
    6 ```
     10}}}
    711Looks like the underlying proj lookup using SPI is not happy w/ the parallel executor.