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

[Florian Reimer]

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