I have this command
ogr2ogr -update -append -f PostgreSQL PG:... merged.gpkg
which works ok in version 3.0.2 (self-compiled) but not in 2.2.3 (from
ubuntu apt). The error is
ERROR: duplicate key value violates unique constraint "stand_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY stand, line 1
STATEMENT: COPY "stand" ("wkb_geometry", "standid", "parcelid",
"realestateid", "standnumber", "standnumberextension", "maingroup",
"subgroup", "fertilityclass", "soiltype", "drainagestate",
"ditchingyear", "thinningyear", "developmentclass", "standquality",
"maintreespecies", "accessibility", "standinfo", "datasource",
"growthplacedatasource", "area", "areadecrease", "creationtime",
"updatetime") FROM STDIN;
The issue is that "stand_pkey" is "CONSTRAINT stand_pkey PRIMARY KEY
(id)" made by the
ogr2ogr -overwrite -f PostgreSQL PG:... merged.gpkg
earlier. So it shouldn't be in the COPY data at all (the log does not
show whether it is there) or there is something wrong with the sequence.
Is there a way to make it work in the older version?
Ari
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev
