[Qgis-user] db manager plugin problem loading features from esri personal geodb

Pietro Rossin pierigis at gmail.com
Wed Aug 7 05:53:57 PDT 2013


Hello community
I'm using Qgis Master and db manager plugin updated today.
In qgis I can load an esri personal geodb polyline layer correctly
If I try to upload to a postgis schema with dbmanager I get an error after a
while.
I select to create a primary key, to call "geom" the geometry column, I set
the source and targhet SRID (the same) and I tell db manager to create
spatial index.
Dbmanager don't let me select to append data (radio button grayed out)
neither let me select to create single geometries instead of multiple ones.

The error I get is:

Errore nella creazione di elementi da #0 a #0. L'errore della sorgente dati
è: 
Errore PostGIS nell'aggiunta delle geometrie: ERROR:  Geometry type
(MultiLineString) does not match column type (LineString)

Errore nella creazione di elementi da #0 a #0. L'errore della sorgente dati
è: 
Errore PostGIS nell'aggiunta delle geometrie: ERROR:  Geometry type
(MultiLineString) does not match column type (LineString)

.....
Stop dopo 1200 errori
Scritti solo 2800 di 4000 elementi.

In pgadminIII I can see that the table is created and approx. 2800 features
are added and I can load them in qgis..

So, dbmanager by default create a linestring geometry column and my data are
multilinestring

If I create a table with a multilinestring geometry column dbmanager don't
let me append data (button grayed)..
If I move to a shp and then to a postgis I can loose field names
So
What can I do??

Thank you all
Pietro



--
View this message in context: http://osgeo-org.1560.x6.nabble.com/db-manager-plugin-problem-loading-features-from-esri-personal-geodb-tp5071294.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.



More information about the Qgis-user mailing list