The relation 303702 and many others in the table asked 05 Oct '18, 12:44 ppKrauss |
2 Answers:
You could use the answered 05 Oct '18, 13:13 Frederik Ramm ♦ |
If it is the truth, as @FraderikRamm say "there's no particular osm2pgsql option that would do this for you"... The only solution is by SQL,
so, now we have a UNIQUE(osm_id,sub_id). Complete solution(can be repeated changing table name)
answered 05 Oct '18, 14:08 ppKrauss edited 10 Oct '18, 00:27 |
The
--multi-geometry
is a good clue, I will test in the next planet-conversion... And will back here with results. If there are no complete solution, my answer below is a workaround using pure SQL and perhapsALTER TABLE
(adding UNIQUE clause to index it) enhance performance.