Bug report #5629

Unable to import a layer containing multipart and/or 3D geometries

Added by Ian Packham over 8 years ago. Updated over 1 year ago.

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

Description

When dropping a shapefile into DB Manager, PG connection, I get an error message with no text.

The "Import vector layer" dialog remains open. After refreshing DB Manager, the layer exists, although no spatial index has been added if requested.

The shapefile in question was given to the DB Manager developer at the Lyon Hackfest - RiverSubBasins.shp (larger than 5MB).

History

#1 Updated by Giuseppe Sucameli over 8 years ago

  • Assignee set to Giuseppe Sucameli

It was fixed the last day of the HF, just after you left it ;)
If you're using one of the latest QGis 1.8 you should get a meaningful error message.

About the spatial index problem, there's also another ticket (#5625) which reports the same problem. I'm fixing it.

#2 Updated by Giuseppe Sucameli over 8 years ago

  • Subject changed from Error message blank when dropping shapefile to Unable to import a layer containing multipart and/or 3D geometries

The problem is due to multipart and 3D geometries, not supported yet.

The error message looks like the following one:

Creation error for features from #0 to #199. Provider errors was: 
PostGIS error while adding features: ERROR:  Geometry type (MultiLineString) does not match column type (LineString)
...
Creation error for features from #400 to #599. Provider errors was: 
PostGIS error while adding features: ERROR:  Geometry has Z dimension but column does not

#3 Updated by Ian Packham over 8 years ago

Yes, I get the error message now.

Maybe some documentation or note on the start screen is needed to inform users that Multi-geometries are not supported yet? Although I see Spit does the same thing.

From the same .shp file I left with you, I also get this message:

Creation error for features from #600 to #799. Provider errors was: 
PostGIS error while adding features: ERROR:  numeric field overflow
DETAIL:  A field with precision 19, scale 11 must round to an absolute value less than 10^8.

Not sure which field this is referring to, but there are some numeric fields. I guess this would break the loading of this shapefile even if the other problem didn't?

#4 Updated by Giovanni Manghi almost 8 years ago

  • Crashes QGIS or corrupts data set to No
  • Affected QGIS version set to master
  • Project changed from 27 to QGIS Application

#5 Updated by Giovanni Manghi almost 8 years ago

  • Category set to DB Manager

#6 Updated by Giovanni Manghi almost 8 years ago

  • Assignee deleted (Giuseppe Sucameli)

#7 Updated by Giovanni Manghi over 3 years ago

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

#8 Updated by Giovanni Manghi over 1 year ago

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

Also available in: Atom PDF