db manager don't load esri personal geodb to postgis single feature instead of multi created

[qgib]

Author Name: Pietro Rossin (Pietro Rossin)
Original Redmine Issue: 8437
Affected QGIS version: master
Redmine category:db_manager

---

I'm using the dev version in windows 1.9.0 (1.9.0-Master Revisione codice QGIS d821bcc)
loading a polyline feature from an esri 9.2 personal geodb I get an error after 2800 features loaded (the table is created).
This error is about the loading of multilinestring into a linestring geometry column.
Db manager also don't let me append features into a table, created with pgadminIII with the correct geometry column type, because of the radio button grayed out.

[qgib]

Author Name: Regis Haubourg (@haubourg)

---

The problem can be extended to all datasources containing multi and single objects. If faced it with a shape2postgis today.
I guess Dbmanager should test all objects for being multi or single geometries before declaring constraints and geometry_columns info (postgis < 2.0).
I think we should raise the priority of that issue because most datasets are affected.
Cheers
Régis

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• easy_fix was configured as 0
• regression was configured as 0

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

End of life notice: QGIS 2.18 LTR
*
Source:*
http://blog.qgis.org/2019/03/09/end-of-life-notice-qgis-2-18-ltr/

---

• resolution was changed from to end of life
• status_id was changed from Open to Closed