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

[strk]

On Fri, Mar 19, 2004 at 10:06:56AM +0100, Jan Hartmann wrote:
> 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

Can you send a diff of the two outputs (or send them all) ?

> psql:test.sql:1: ERROR:  column not found in geometry_columns table

This seems to come out from DropGeometryColumn

> 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.

This is probably coming from AddGeometryColumn
But it's a long time it doesn't issue that message anymore.

What version of postgis is installed ? 

--strk;

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