[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