[postgis-users] shp2pgsql not loading in 0.8.2
Seamus Thomas Carroll
carrolls@cpsc.ucalgary.ca
Thu Jan 15 04:59:01 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@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@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