importing shapefile into PG with drag and drop does not work

[qgib]

Author Name: Giovanni Manghi (@gioman)
Original Redmine Issue: 6907
Affected QGIS version: master
Redmine category:db_manager

---

I can import the attached shapefile using DB manager new "load layer" function, and it takes just a few seconds as it does SPIT, but if I try to import it using the D&D from the qgis browser then the operation never ends (or if it ends it takes ages).

The issue seems to be the following:

the shape has already an "id" column and DB manager try to use the same name for the primary key. In QGIS 1.8 the import fails with an error (column duplicate), while in master the process goes nowhere.

if the primary key column name is changed manually then it works as expected.

I'm testing using a local PG server.

---

• shape.zip (Giovanni Manghi)

[qgib]

Author Name: Paolo Cavallini (@pcav)

---

• assigned_to_id was changed from Giuseppe Sucameli to anonymous

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

Fixed in changeset "460f578d937e640e1690af53c08710575012a620".

---

• status_id was changed from Open to Closed

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

• assigned_to_id removed anonymous