Opened 8 years ago

Closed 8 years ago

#3636 closed defect (fixed)

AddGeomtryColumn is not parallel safe

Reported by: komzpa Owned by: robe
Priority: blocker Milestone: PostGIS 2.3.0
Component: postgis Version: master
Keywords: Cc:

Description

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

Change History (2)

comment:1 by strk, 8 years ago

Owner: changed from pramsey to robe
Priority: mediumblocker

comment:2 by robe, 8 years ago

Resolution: fixed
Status: newclosed

In 15124:

AddGeometryColumn should not be marked parallel safe
closes #3636

Note: See TracTickets for help on using tickets.