Hi, Maybe this case is known (also a google search didn't pointed me to it) but osm2pgsql diff adding mode fails when there is a tag with upercase caracters
Sorry if that bug report is in the wrong place : postg...@binael:/home/postgresql $ svn co http://svn.openstreetmap.org/applications/utils/export/osm2pgsql/ (...) postg...@binael:/home/postgresql $ cd osm2pgsql postg...@binael:/home/postgresql $ make (...) postg...@binael:/home/postgresql $ cat test.style node,way IN text linear postg...@binael:/home/postgresql $ ./osm2pgsql/osm2pgsql -s -S ./test.style -d not_osm /tmp/test.osm osm2pgsql SVN version 0.67-18306 Using projection SRS 900913 (Spherical Mercator) Setting up table: planet_osm_point Setting up table: planet_osm_line Setting up table: planet_osm_polygon Setting up table: planet_osm_roads Mid: pgsql, scale=100, cache=800MB, maxblocks=102401*8192 Setting up table: planet_osm_nodes NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_nodes_pkey" for table "planet_osm_nodes" Setting up table: planet_osm_ways NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_ways_pkey" for table "planet_osm_ways" Setting up table: planet_osm_rels NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_rels_pkey" for table "planet_osm_rels" Reading in file: /tmp/test.osm WARNING: Found Out of order node 298786602 (2388935,810) - this will impact the cache efficiency Processing: Node(0k) Way(0k) Relation(0k) Node stats: total(219), max(452930789) Way stats: total(5), max(38344957) Relation stats: total(0), max(0) Going over pending ways Going over pending relations Committing transaction for planet_osm_line Committing transaction for planet_osm_roads node cache: stored: 111(50.68%), storage efficiency: 1.35%, hit rate: nan% Stopping table: planet_osm_nodes Committing transaction for planet_osm_point Stopping table: planet_osm_ways Stopping table: planet_osm_rels Sorting data and creating indexes for planet_osm_line Sorting data and creating indexes for planet_osm_roads Committing transaction for planet_osm_polygon Building index on table: planet_osm_rels Sorting data and creating indexes for planet_osm_point Building index on table: planet_osm_ways Stopped table: planet_osm_rels Stopped table: planet_osm_ways Sorting data and creating indexes for planet_osm_polygon Stopped table: planet_osm_nodes Completed planet_osm_roads Completed planet_osm_point Completed planet_osm_polygon Completed planet_osm_line postg...@binael:/home/postgresql $ ./osm2pgsql/osm2pgsql -a -s -S ./test.style -d not_osm 200910251215-200910251216.osc.gz osm2pgsql SVN version 0.67-18306 Using projection SRS 900913 (Spherical Mercator) Setting up table: planet_osm_point Adding new column "IN" to "planet_osm_point" ALTER TABLE planet_osm_point ADD COLUMN "IN" text; failed: ERROR: column "IN" of relation "planet_osm_point" already exists Error occurred, cleaning up -- sly Sylvain Letuffe [email protected] qui suis-je : http://slyserv.dyndns.org _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
