[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