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
> [email protected]
> http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
