[Tile-serving] [osm2pgsql-dev/osm2pgsql] Duplicate rows in roads/line/polygon tables ? (Discussion #2441)

[Christian Quest]

Fine for me !
I did not open issue for that for the reason you mentionned, just wanted to share my findings.

Just in case, here is a query to remove those duplicates:
`delete from planet_osm_polygon where ctid in (select ctid from (select ctid, row_number() over (partition by osm_id, way order by osm_id) as row_num from planet_osm_polygon) t where row_num>1);`


-- 
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2441#discussioncomment-15325528
You are receiving this because you are subscribed to this thread.

Message ID: <osm2pgsql-dev/osm2pgsql/repo-discussions/2441/comments/15325528 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20251223/bfc58a5e/attachment-0001.htm>