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 , 8 years ago
Owner: | changed from | to
---|---|
Priority: | medium → blocker |
comment:2 by , 8 years ago
Resolution: | → fixed |
---|---|
Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
In 15124: