[postgis-users] Schema support in loader/dumper]

[Jan Hartmann]

Hi strk,


Perhaps I'm doing something very dumb. However,

bin_0.8.0/shp2pgsql -s 28992 -d test.shp test zl > test.sql
psql -d zl -f test.sql

works, while

bin_0.8.1/shp2pgsql -s 28992 -d test.shp test zl > test.sql
psql -d zl -f test.sql

gives the following errors


psql:test.sql:1: ERROR:  column not found in geometry_columns table
DROP TABLE
psql:test.sql:3: NOTICE:  CREATE TABLE will create implicit sequence 
"test_gid_seq" for "serial" column "test.gid"
CREATE TABLE
psql:test.sql:4: ERROR:  Invalid database name.
BEGIN
psql:test.sql:6: ERROR:  column "the_geom" of relation "test" does not exist
psql:test.sql:7: ERROR:  current transaction is aborted, commands 
ignored until end of transaction block
psql:test.sql:8: ERROR:  current transaction is aborted, commands 
ignored until end of transaction block
psql:test.sql:9: ERROR:  current transaction is aborted, commands 
ignored until end of transaction block
psql:test.sql:10: ERROR:  current transaction is aborted, commands 
ignored until end of transaction block
psql:test.sql:11: ERROR:  current transaction is aborted, commands 
ignored until end of transaction block
COMMIT
psql:test.sql:12: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create 
implicit index "test_pkey" for table "test"
ALTER TABLE
  setval