[OSM-dev] osm2pgsql

[bdepaepe at latitude-geosystems.com]

hi,

I try to import france.osm (obtained from downloads.cloudmade.com)  
into PostGIS db using :
osm2pgsql -U postgres -W -E 900913 -s -d osm_france  
/home/bart/Desktop/france.osm

The import encounters an error and terminates:
***
Reading in file: /home/bart/Desktop/france.osm
Processing: Node(38320k) Way(0k) Relation(0k)COPY_END for COPY  
planet_osm_nodes FROM STDIN;
  failed: ERROR:  duplicate key value violates unique constraint  
"planet_osm_nodes_pkey"
CONTEXT:  COPY planet_osm_nodes, line 8934: "361095     625272091       
  26207008        {"highway","traffic_signals"}"
***

I found an old post on your mailing list about this error:
http://lists.openstreetmap.org/pipermail/dev/2008-August/011579.html

However, when looking into my osm2pgsql.c this patch has been  
implemented in the meantime so it should work.

The import of belgium.osm encountered the same error, so it is not due  
to the input file.

thanks for your help,

Bart