[postgis-users] shp2pgsql and schemas

strk strk at keybit.net
Thu Dec 11 03:03:50 PST 2003


Can I take a look at your patches, please ?
--strk;

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



More information about the postgis-users mailing list