[postgis-tickets] [PostGIS] #3636: AddGeomtryColumn is not parallel safe

[PostGIS]

#3636: AddGeomtryColumn is not parallel safe
---------------------+---------------------------
 Reporter:  komzpa   |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:  PostGIS 2.3.0
Component:  postgis  |    Version:  trunk
 Keywords:           |
---------------------+---------------------------
 {{{
 shp2pgsql -s 3857  -g geom -I data/osm/water_polygons.shp water_polygons |
 psql
 Shapefile type: Polygon
 Postgis type: MULTIPOLYGON[2]
 Expanded display is used automatically.
 Null display is "¤".
 Line style is unicode.
 Border style is 2.
 Timing is on.
 SET
 Time: 0,189 ms
 SET
 Time: 0,058 ms
 BEGIN
 Time: 0,034 ms
 CREATE TABLE
 Time: 3,782 ms
 ALTER TABLE
 Time: 1,649 ms
 ERROR:  25000: cannot execute ALTER TABLE during a parallel operation
 CONTEXT:  SQL statement "ALTER TABLE public.water_polygons ADD COLUMN geom
 geometry(MultiPolygon, 3857)"
 PL/pgSQL function addgeometrycolumn(character varying,character
 varying,character varying,character varying,integer,character
 varying,integer,boolean) line 110 at EXECUTE
 SQL statement "SELECT AddGeometryColumn('',$1,$2,$3,$4,$5,$6,$7)"
 PL/pgSQL function addgeometrycolumn(character varying,character
 varying,character varying,integer,character varying,integer,boolean) line
 5 at SQL statement
 parallel worker
 LOCATION:  PreventCommandIfParallelMode, utility.c:254
 Time: 51,580 ms
 }}}

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