Bug report #8437

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

Added by Pietro Rossin over 6 years ago. Updated 11 months ago.

Status:Closed
Priority:Normal
Assignee:-
Category:DB Manager
Affected QGIS version:master Regression?:No
Operating System:windows Easy fix?:No
Pull Request or Patch supplied:No Resolution:end of life
Crashes QGIS or corrupts data:No Copied to github as #:17206

Description

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.

History

#1 Updated by Regis Haubourg about 6 years ago

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

#2 Updated by Giovanni Manghi over 2 years ago

  • Easy fix? set to No
  • Regression? set to No

#3 Updated by Giovanni Manghi 11 months ago

  • Resolution set to end of life
  • Status changed from Open to Closed

Also available in: Atom PDF