[OSM-dev] [OSM-talk] Oh dear - planet has duplicate id's

Raphaël Jacquot sxpert at sxpert.org
Thu May 31 13:36:19 BST 2007

Tom Hughes wrote:
> I was trying to make the ruby migration script (which is what we're
> apparently supposed to use to create OSM databases) match the schema
> from create_database.sql (which RichardF reckoned was more or less
> what was actually in use on the live system).
> One of the principle problems I ran into was that I don't think some
> of the things in that schema can actually be expressed through the
> ruby schema stuff at all! One example is multi-component primary keys
> as it only seems to want to do single component ones. You can of
> course just create a unique index instead, which is more or less
> the same thing.
> I also couldn't see to specify an auto-incrementing column - I assume
> that where ruby is allowed to create the id column itself it will do
> that (or how else do new ID's get allocated?) but I couldn't see a way
> to do it when we need to create the id ourselves.
> 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...

More information about the dev mailing list