[postgis-users] shp2pgsql and schemas

[strk]

I remember there has been discussions about this back this year :)
Check the archives...

--strk;


carrolls wrote:
> Hi,
> 
> I have used shp2pgsql in a version released sometime before the summer and
> there used to be an arguement for the schema and the table.
> 
> shp2pgsql for 0.8.0 does not have this option.  I thought I could just
> input both piece of information in the table arguement ( schema.table )
> but this results in the error when loading the file using psql:
> NOTICE:  CREATE TABLE will create implicit sequence "carrolls_route_alberta_test_gid_seq" for "serial" column "carrolls_route_alberta_test.gid"
> psql:toload.sql:1: NOTICE:  CREATE TABLE will create implicit sequence "carrolls_route_alberta_test_gid_seq" for "serial" column "carrolls_route_alberta_test.gid"
> CREATE TABLE
> ERROR:  relation "roads.carrolls_route_alberta_test" does not exist
> CONTEXT:  PL/pgSQL function "addgeometrycolumn" line 38 at execute statement
> psql:toload.sql:2: ERROR:  relation "roads.carrolls_route_alberta_test" does not exist
> CONTEXT:  PL/pgSQL function "addgeometrycolumn" line 38 at execute statement
> BEGIN
> ERROR:  column "the_geom" of relation "carrolls_route_alberta_test" does not exist
> psql:toload.sql:4: ERROR:  column "the_geom" of relation "carrolls_route_alberta_test" does not exist
> ERROR:  current transaction is aborted, commands ignored until end of transaction block
> ....
> and so on.
> 
> What is the new technique for loading gis data into a schema other than
> public?
> 
> Seamus
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users