[Tile-serving] [osm2pgsql] ids used multiple times (#33)

[michael1e23]

Thanks for the information.

Now i encountered another problem. Is there any reason why there could be the same osm_id of a point used multiple times. I could not trace it down yet when it happened, but look:

```
osm=# SELECT * from planet_osm_point where name='Frauenberg' AND place='village';
  osm_id   | access | addr:housename | addr:housenumber | addr:interpolation | admin_level | aerialway | aeroway | amenity | area | barrier | bicycle | brand | bridge | boundary | building | capital | construction | covered | culvert | cutting | denomination | disused | ele | embankment | foot | generator:source | harbour | highway | historic | horse | intermittent | junction | landuse | layer | leisure | lock | man_made | military | motorcar |    name    | natural | office | oneway | operator |  place  | poi | population | power | power_source | public_transport | railway | ref | religion | route | service | shop | sport | surface | toll | tourism | tower:type | tunnel | water | waterway | wetland | width | wood | z_order | timezone |                        way                         | name:en | flag 
-----------+--------+----------------+------------------+--------------------+-------------+-----------+---------+---------+------+---------+---------+-------+--------+----------+----------+---------+--------------+---------+---------+---------+--------------+---------+-----+------------+------+------------------+---------+---------+----------+-------+--------------+----------+---------+-------+---------+------+----------+----------+----------+------------+---------+--------+--------+----------+---------+-----+------------+-------+--------------+------------------+---------+-----+----------+-------+---------+------+-------+---------+------+---------+------------+--------+-------+----------+---------+-------+------+---------+----------+----------------------------------------------------+---------+------
 287938013 |        |                |                  |                    |             |           |         |         |      |         |         |       |        |          |          |         |              |         |         |         |              |         |     |            |      |                  |         |         |          |       |              |          |         |       |         |      |          |          |          | Frauenberg |         |        |        |          | village |     | 544        |       |              |                  |         |     |          |       |         |      |       |         |      |         |            |        |       |          |         |       |      |         |          | 0101000020E6100000C7F143A511831C406A7121EA99914840 |         | 
 287938013 |        |                |                  |                    |             |           |         |         |      |         |         |       |        |          |          |         |              |         |         |         |              |         |     |            |      |                  |         |         |          |       |              |          |         |       |         |      |          |          |          | Frauenberg |         |        |        |          | village |     | 544        |       |              |                  |         |     |          |       |         |      |       |         |      |         |            |        |       |          |         |       |      |         |          | 0101000020E6100000C7F143A511831C406A7121EA99914840 |         | 
(2 rows)
```
I appended filtered osm portions several times, thats why i could not track it down yet.



---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/33#issuecomment-18796375
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20130601/285c4baa/attachment.html>