[OSM-dev] [OSM-talk] Oh dear - planet has duplicate id's
tom at compton.nu
Thu May 31 14:05:32 BST 2007
In message <465EC6CA.8000705 at SSpaeth.de>
Sebastian Spaeth <Sebastian at SSpaeth.de> wrote:
> Raphaël Jacquot wrote:
>> Tom Hughes wrote:
>>> There are also some inconsistencies, where a field in one table has a
>>> subtly different type to the corresponding field in another table (for
>>> example gpx_id is something int(20) and sometimes bigint(64)).
>>> Some of the index choices look pretty dubious as well - not only does
>>> current_segments not have a unique index on id, it has a non-unique one
>>> on id+visible which is a bit odd if id is supposed to be unique ;-)
>> I've been saying that for a while, but no one was listening...
> perhaps a specific patch with some background info to the list and cc to
> SteveC would help? :-)
I did say I had started trying to write a patch... It's a bit
complicated here though as will also need an SQL script to bring
the server inline at a guess.
Tom Hughes (tom at compton.nu)
More information about the dev