[Tile-serving] [osm2pgsql] o5c update causes "duplicate key value violates unique constraint" error (#133)

kayrus notifications at github.com
Thu Apr 17 12:38:41 UTC 2014


When I try to update osm postgresql database from o5c file, osm2pgsql fails with the following message:
```
Processing: Node(14829k 1.4k/s) Way(669k 0.06k/s) Relation(0 0.00/s)
insert_way failed: ERROR:  duplicate key value violates unique constraint "planet_osm_ways_pkey"
DETAIL:  Key (id)=(273191556) already exists.

```
if it makes sense, o5c was created from osc file by osmconvert utility:

```
osmconvert {576..580}.osc.gz --emulate-osmosis --fake-lonlat --merge-versions --out-o5c >  cumulative.o5c

```
osc update works perfectly:
```
osmconvert {576..580}.osc.gz --emulate-osmosis --fake-lonlat --merge-versions --out-osc >  cumulative.osc
```

---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/133
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20140417/7425ee18/attachment.html>


More information about the Tile-serving mailing list