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

[Christian Quest]

I've found a few duplicated rows in the planet_osm_roads table on one of the world databases.
This database is quite old, and has been updated using diff for several years.

They all happened on geometries originating from relations (boundaries, etc).
I've not yet checked the line and polygon tables.

I discovered that by trying to create a unique index on these tables in order to be able to use pg_repack to vacuum/cluster these tables without global lock.

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

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