Bug report #6279
ERROR: duplicate key value violates unique constraint...
|Affected QGIS version:||master||Regression?:||No|
|Operating System:||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:||fixed|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||15579|
When importing a vector into PostGIS with DB manager, if the original vector has already a column "id" then the tool will give
Creation error for features from #0 to #0. Provider errors was:
PostGIS error while adding features: ERROR: duplicate key value
violates unique constraint "table_name_pkey"
DETAIL: Key (id)=(0) already exists.
As "id" is very common (unless the old "gid") I guess that a check should be added before trying to import the vector.
#4 Updated by Giuseppe Sucameli about 7 years ago
- Resolution set to fixed
Fixed for QGis Friendly Courses http://www.qgis.org/en/sponsorship/qgis-friendly-courses.html