[postgis-users] shp2pgsql not loading in 0.8.2

Seamus Thomas Carroll carrolls at cpsc.ucalgary.ca
Wed Jan 14 20:59:01 PST 2004


Hi,

I have been playing with postgis 0.8.2 and it now gives me an error when 
running shp2pgsql when 0.8.1 did not.  I am trying to load dmti spatial 
data on the BC road network.  I have provided outputs comparing the two 
versions below.

carrolls at ict715b:> /scratch/postgresql-7.4/contrib/postgis-0.8.0/loader/shp2pgsql 
/home/vraid2/carrolls/dmti/AB_BC_MB_SK/ArcView/Nad83/CanMapRL/BC/Streets/BCrte.shp 
BCrte noschema > toload.sql
carrolls at ict715b:> /scratch/postgresql-7.4/contrib/postgis-0.8.1/loader/shp2pgsql 
/home/vraid2/carrolls/dmti/AB_BC_MB_SK/ArcView/Nad83/CanMapRL/BC/Streets/BCrte.shp 
BCrte > toload.sql
Error: field 20 has invalid or unknown field type (3)

I noticed that AddGeometryColumn now allows for schemas which is great but 
shp2pgsql.c v1.45 0.8.2 does not appears to allow for schemas.  Am I 
missing a simple way of loading shape files into specific schemas other 
than editing the created sql statements?  Could an extra arguement be 
added to shp2pgsql for the schema and if one is not given 
default to the public schema?

Seamus




More information about the postgis-users mailing list