ERROR: duplicate key value violates unique constraint...

[qgib]

Author Name: Giovanni Manghi (@gioman)
Original Redmine Issue: 6279
Affected QGIS version: master
Redmine category:db_manager
Assignee: Giuseppe Sucameli

---

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.

[qgib]

Author Name: Paolo Cavallini (@pcav)

---

• fixed_version_id was configured as Version 2.0.0

[qgib]

Author Name: Giuseppe Sucameli (@brushtyler)

---

Fixed in changeset "0239795d7931b614be22e87d12beecf20372b5c6".

---

• status_id was changed from Open to Closed

[qgib]

Author Name: Giuseppe Sucameli (@brushtyler)

---

Now the new field name is not passed from DBManager to the provider unless the user tick the "primary key" checkbox.
The provider checks the field name list and chooses a different name whether the default one (i.e. "id") exists yet.

[qgib]

Author Name: Giuseppe Sucameli (@brushtyler)

---

Fixed for QGis Friendly Courses http://www.qgis.org/en/sponsorship/qgis-friendly-courses.html

---

• resolution was changed from to fixed