[osmosis-dev] Simple schema creation with osmosis-0.38

[bigspoon]

Hello,
I'm using osmosis-0.38 on Ubuntu10.10.

When I try to create a simple osmosis schema on PostGIS 8.4 DB (see below) I
get some questionable output that tells me certain entities in the DB 'does
not exist'. This seems reasonable -- why would relations exist if I haven't
imported them yet. I'm wondering if this is normal output for a clean
osmosis schema run? Assuming it did go off right, I then try importing a bz2
file into the schema and get a more wicked error that also says "nodes does
not exist" (also below). This makes me think the schema script didn't finish
correctly. Any ideas?


*command: *

$ psql -d OSMOSIS_OSM -U gcorradini -W -f
/usr/local/src/osmosis/osmosis-0.38/script/pgsql_simple_schema_0.6.sql

*end of output:*

psql:/usr/local/src/osmosis/osmosis-0.38/script/pgsql_simple_schema_0.6.sql:71:
ERROR:  type "hstore" does not exist
LINE 7:     tags hstore
                 ^
CREATE TABLE
INSERT 0 1
psql:/usr/local/src/osmosis/osmosis-0.38/script/pgsql_simple_schema_0.6.sql:88:
NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index
"pk_schema_info" for table "schema_info"
ALTER TABLE
psql:/usr/local/src/osmosis/osmosis-0.38/script/pgsql_simple_schema_0.6.sql:90:
NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "pk_users"
for table "users"
ALTER TABLE
psql:/usr/local/src/osmosis/osmosis-0.38/script/pgsql_simple_schema_0.6.sql:92:
ERROR:  relation "nodes" does not exist
psql:/usr/local/src/osmosis/osmosis-0.38/script/pgsql_simple_schema_0.6.sql:94:
ERROR:  relation "ways" does not exist
psql:/usr/local/src/osmosis/osmosis-0.38/script/pgsql_simple_schema_0.6.sql:96:
NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index
"pk_way_nodes" for table "way_nodes"
ALTER TABLE
psql:/usr/local/src/osmosis/osmosis-0.38/script/pgsql_simple_schema_0.6.sql:98:
ERROR:  relation "relations" does not exist
psql:/usr/local/src/osmosis/osmosis-0.38/script/pgsql_simple_schema_0.6.sql:100:
NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index
"pk_relation_members" for table "relation_members"
ALTER TABLE
psql:/usr/local/src/osmosis/osmosis-0.38/script/pgsql_simple_schema_0.6.sql:104:
ERROR:  relation "nodes" does not exist
CREATE INDEX
CREATE INDEX
psql:/usr/local/src/osmosis/osmosis-0.38/script/pgsql_simple_schema_0.6.sql:112:
ERROR:  relation "nodes" does not exist
psql:/usr/local/src/osmosis/osmosis-0.38/script/pgsql_simple_schema_0.6.sql:130:
ERROR:  invalid type name "ways.id%TYPE"
LINE 3:  previousId ways.id%TYPE;
                    ^
CREATE FUNCTION


*import command:*
$ bzcat /home/gcorradini/WRK/osmosis_working/bbox_extracts/gaza.osm.bz2 |
/usr/local/src/osmosis/osmosis-0.38/bin/osmosis --read-xml file=/dev/stdin
--write-pgsql database="OSMOSIS_OSM" user="gcorradini" password="gregc"
host="localhost"

*
truncated output:*
Jun 22, 2011 8:26:18 AM
org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager
waitForCompletion
SEVERE: Thread for task 1-read-xml failed
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL
grammar [ALTER TABLE nodes DROP CONSTRAINT pk_nodes]; nested exception is
org.postgresql.util.PSQLException: ERROR: relation "nodes" does not exist




--
View this message in context: http://gis.638310.n2.nabble.com/Simple-schema-creation-with-osmosis-0-38-tp6504881p6504881.html
Sent from the Osmosis Development mailing list archive at Nabble.com.