[Qgis-user] DB manager PostGIS import fails for strange reason

[Mats Elfström]

Hi again!

Andrea Giudiceandrea responded :"*it seems to me the error message
says the contrary: you are trying to import MultiPolygon geometries in
a Polygon column geom type table.*"

Well I am not sure about that. It may be a semantic matter.
The PostGIS table is non-existent at the time of import, so the importer
can create any geometry type needed. Preferably polygon since the table in
the geopackage has geometrytype=Polygon.
And the error message "*PostGIS error while adding features: ERROR:
 Geometry type (MultiPolygon) does not match column type (Polygon)*" does
not really define origin and target.
Knowing that the geopackage table is polygon I assumed that for some reason
a PostGIS multipolygon table was created, causing the mismatch.

But let us assume that you are right - that the origin really is
multipolygon - how can I specify that a multipolygon table be created when
importing it to PostGIS?

Regards, Mats.E

-- 


*GisKraft*, Geodatakonsult

Mats Elfström, Marsvinsholms stationsväg 80, 271 93 Ystad, Sweden
tel: +46 70 595 39 35 / www.giskraft.se
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20220727/29e8435b/attachment.htm>