[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