[postgis-users] shp2pgsql and schemas

[aaronkoning at shaw.ca]

Hi Seamus,

This is actually a modified version that I created for the UNBC Datashare, since we wanted to use other schemas than public. There is a patch for postgis 0.7.5 on our pages under: development/code_db_method_doc.php#postgis_changes

Aaron Koning

----- Original Message -----
From: Seamus Thomas Carroll <carrolls at cpsc.ucalgary.ca>
Date: Wednesday, December 10, 2003 3:05 pm
Subject: [postgis-users] shp2pgsql and schemas

> 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 
> statementpsql:toload.sql:2: ERROR:  relation 
> "roads.carrolls_route_alberta_test" does not exist
> CONTEXT:  PL/pgSQL function "addgeometrycolumn" line 38 at execute 
> statementBEGIN
> 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 
> thanpublic?
> 
> Seamus
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>