If you consume minutely diffs to keep a local copy of OSM data you can end up in a situation where you think two user IDs have the same user name. For pgsnapshot these duplicates can be found with
SELECT COUNT(*), name FROM users GROUP BY name HAVING COUNT(*) > 1 The following command should fix all of the duplicates in a pgsnapshot database. Other schemas may require different commands. UPDATE users SET name = 'Agno-phi' WHERE id = 731498; UPDATE users SET name = 'GrantHeaslip' WHERE id = 476533; UPDATE users SET name = 'user_1715095' WHERE id = 1715095; UPDATE users SET name = 'MartinUpOld' WHERE id = 993945; UPDATE users SET name = 'Dan Baránek' WHERE id = 307530; UPDATE users SET name = 'Accelerated Global - Internet Marketing' WHERE id = 1431117; UPDATE users SET name = '0000000000000' WHERE id = 878213; If you have a local PBF file, I'm not sure the best way to fix it. Probably re-download. _______________________________________________ dev mailing list [email protected] https://lists.openstreetmap.org/listinfo/dev
