Hi Thomas, I think you have the wrong schema installed. There is no node_tags table in the schema. There used to be in older versions of the schema.
Can you try a couple of things please? - Remove the validateSchemaVersion="no" option from your Osmosis command line. You don't need it and it can hide the real problem. - Re-create your schema from the 0.38 distribution. The 0.38 script doesn't create a node_tags table, it creates a hstore tags column on the nodes table. The below script should be the one you are using. http://svn.openstreetmap.org/applications/utils/osmosis/tags/0.38/package/script/pgsql_simple_schema_0.6.sql - Make sure that no errors occur during execution of the above script. - You may need to install "hstore" support in your database. Your PostgreSQL distribution should provide this script. - Note that the scripts are in the "script" directory, not in the "script/contrib" directory. Do NOT use the "script/contrib/apidb_0.6.sql" script. There are no step by step instructions on debugging Osmosis, however there are some basic instructions on configuring Eclipse. http://wiki.openstreetmap.org/wiki/Osmosis/Development#Eclipse_Setup If you do want to test it in Eclipse, run the existing JUnit tests in the "pgsnapshot" project from within Eclipse. Cheers, Brett On Thu, Dec 16, 2010 at 8:05 PM, Thomas Schreiner <schreiner.tho...@gmx.net>wrote: > Hello Brett, > > my english is also not so well, but we can at least communicate. > What I did is, I set up a postgres 8.4 database, create a user and a > database. Run the sql script pgsql_simple_schema_0.6.sql from the 0.38 > distribution out of the directory script/contrib. > > I downloaded a pbf file from download.geofabrik.de an try to import these > pbf file. > The first error message I got was about the schema version, so I turned the > validation of the schema of. > > Then I got the error with the index, no idea why the index is not created > in the sql script. Never then less I changed the code as described bevor. > > Now I get the error message that the node table has no tags column. That's > right, because there is another table called node_tags. A node can have > several tags, e.g. house number, telephone number, name, amenity, ... > > So I had also a look into the sql script which creates the postgres schema, > but I find nothing strange. > > Can you tell me how to set up osmosis via svn in eclipse to be able to > debug the application? Is there a step by step documentation? > > Thanks > > Thomas > > -------- Original-Nachricht -------- > > Datum: Thu, 16 Dec 2010 18:58:51 +1100 > > Von: Brett Henderson <br...@bretth.com> > > An: Thomas Schreiner <schreiner.tho...@gmx.net> > > CC: "osmosis-dev@openstreetmap.org" <osmosis-dev@openstreetmap.org> > > Betreff: Re: [osmosis-dev] Problem with pbf import into a postgres DB > > > Hi Thomas, > > > > My German isn't great, but I'm guessing that the following message is > > complaining about a missing tags column in the nodes table. > > > > FEHLER: Spalte »tags« von Relation »nodes« existiert nicht > > > > I notice you're specifying the following option. > > validateSchemaVersion="no" > > > > Why are you doing that? You need to use a schema version that matches > your > > version of Osmosis. > > > > Brett > > > > > > On 16/12/2010, at 4:10, Thomas Schreiner <schreiner.tho...@gmx.net> > wrote: > > > > nicht > > -- > Thomas Schreiner > Grasslweg 4 > 85049 Ingolstadt > > GMX DSL Doppel-Flat ab 19,99 Euro/mtl.! Jetzt auch mit > gratis Notebook-Flat! http://portal.gmx.net/de/go/dsl >
_______________________________________________ osmosis-dev mailing list osmosis-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/osmosis-dev