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

Raphaël Jacquot sxpert at sxpert.org
Thu May 31 12:59:05 BST 2007


Dan Moore wrote:
> wow - and you know what, it's true - somehow there is no primary / uniqueness constraint on that id:
> 
> http://trac.openstreetmap.org/browser/sites/rails_port/db/create_database.sql#L69
> 
> same goes for current_nodes - compare with current_ways (line 110) which has appropriate primary key declaration.  i see you've filed a ticket on this. perhaps we should move any further discussion to dev at openstreetmap.org.

somehow this appear as a consequence of using rails. the original author
of which considers his code is better at handling referential and data
integrity than whatever the DB server has to offer...




More information about the talk mailing list