[postgis-users] PostGIS Error: Loading with SPIT-Plugin-> MULTINULL

[Ben Madin]

Florian,

I've never used SPIT, but I'm sure you can see that there is no geometry type in postgis known as MULTINULL.  I suspect you might be better to follow this up with the qgis mailing lists.

Does it work using shp2pgsql?

As a second observation, you are using what I think would now be regarded as quite old builds of all the architecture - there may well have been bugs that are long since fixed. If you can try on a more modern set of tools, you might have more luck.

good luck.

cheers

Ben

 


On 10/05/2011, at 4:19 PM, Florian Reimer wrote:

> Hello,
> 
> we have a large Multipolygon Shapefile and try to load it from QGIS into PostGIS via the SPIT-Plugin. The file is recognized only as MULTINULL while it should be MULTIPOLYGON.
> 
> 
> SELECT AddGeometryColumn('public','PA-Prop','the_geom',32617,'MULTINULL',2)
> 
> ERROR: Invalid type name - valid ones are:
> GEOMETRY, GEOMETRYCOLLECTION, POINT,
> MULTIPOINT, POLYGON, MULTIPOLYGON,
> LINESTRING, MULTILINESTRING,
> GEOMETRYCOLLECTIONM, POINTM,
> MULTIPOINTM, POLYGONM, MULTIPOLYGONM,
> LINESTRINGM, or MULTILINESTRINGM
> CONTEXT: SQL statement "SELECT AddGeometryColumn('', $1 , $2 , $3 , $4 , $5 , $6 )"
> PL/pgSQL function "addgeometrycolumn" line 4 at select into variables
> 
> There might be some error with Geometry, though the file works fine in QGIS and ArcGIS. Anyone had this problem before and might know something about it?
> 
> We are using:
> 
> PostGIS
> Library:	1.1.6
> Scripts:	1.1.6
> GEOS:	3.0.0-CAPI-1.4.1
> Proj:	Rel. 4.6.0, 21 Dec 2007
> 
> PostgreSQL 8.1.19 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.1.2 20061115 (prerelease) (Debian 4.1.1-21)
> 
> Thank you very much!
> Florian
> 
> 
> -- 
> Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir
> belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users