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

PostGIS trac at osgeo.org
Wed Jan 10 07:07:34 PST 2018


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

Comment (by pramsey):

 This is more specific than I thought. Using our Carto pgsql branch, which
 has a backport of the pg11 parallel "create table as" support in it, and
 changing to SPI_execute, causes a crash condition. Using generic pg10,
 there is no parallel mode, and no crash condition.
 Running the ST_Transform query without the "create table as" part causes
 **no problems** even when a parallel plan is used. So the problem is
 (currently) specific to the carto branch, but **might also** be something
 that is an issue in pg11 since that's where we pulled the "create table
 as" support from.

 Next test: on pg11 is this use case (parallel "create table as")
 problematic.

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