[postgis-devel] Geometry type does not match column type

[Salvatore Larosa]

Il giorno sab, 24/03/2012 alle 15.37 +0100, Salvatore Larosa ha scritto:
> Hi,
> I'm working with PostGIS tables and noticed some problems, but I can not
> tell if the problem is in QGIS or PostGIS!
> For this reason I am writing to both the mailing list.
> 
> First issue:
> 
> http://hub.qgis.org/issues/5109
> 
> Second:
> 
> If I use the SPIT plugin to import polygon features in PostGIS I get
> this:

> ##########CODE############################################################### 
> Problema nell'inserimento di elementi dal file: 
> /home/sam/test_topology/prov.shp 
> 
> Il database ha restituito un errore durante l'esecuzione di questa 
> istruzione SQL: 
> INSERT INTO 
> "public"."prov"("provincia","cod_pro","sigla","cod_reg","sede","anno_volo","liv_utente","geom") VALUES ('Catanzaro','079','CZ','18',NULL,'.. (omesso l'SQL restante) 
> L´errore era: 
> ERROR:  Geometry type (Polygon) does not match column type 
> (MultiPolygon) 
> ##########END############################################################### 

first issue solved in commit 49456116 (thanks to Jürgen Fischer), it was
due to QGIS and likely, also the issue with SPIT plugin!

Cheers!

-SL