[QGIS-Developer] Importing shp into gpkg or PostGIS as SINGLE geometry gives MULTI?

Paolo Cavallini cavallini at faunalia.it
Tue Oct 1 21:36:58 PDT 2019

Thanks Giovanni for the detailed reply.

On 01/10/19 19:17, Giovanni Manghi wrote:
>     Correct, but in the importing popup there is an option to transform
>     into single. It usually works, at least for points, so it's unclear
>     why it shouldn't in this case.
>     Cheers.
> despite its name, that has been always confusing, that option in DB
> Manager never transformed geometries to SINGLE from MULTI along the
> import process).
> What the option means (meant?) is that if I have a layer that is
> declared as MULTI but actually has no multipart geometries in it, then
> it can be imported as a non-MULTI table.
> In past QGIS releases if you had a layer with a multi-geometry and
> checked that option then DB manager returned an error like
> ...
> now it does not and imports to MULTI anyway and silently. And it does
> also if you don't have any multi-geometry, which of course are both bugs
> and regressions.

agreed. do you know whether there is a ticket for this?
in some cases this is really a blocker.
Paolo Cavallini - www.faunalia.eu

More information about the QGIS-Developer mailing list