[OSM-dev] Database Schema (was Re: [OSM-talk] Oh dear - planet has duplicate id's)

SteveC steve at asklater.com
Sat Jun 23 15:33:36 BST 2007


On 23 Jun 2007, at 15:07, Tom Hughes wrote:

> In message  
> <7679c25f0706230653m427dbbcfv68fafa95dc5faaf6 at mail.gmail.com>
>           "Ray Booysen" <raybooysen at rjb.za.net> wrote:
>
>> Sorry if I'm jumping in late, but I'm finding it a bit strange  
>> that on the
>> most important tables, we're missing primary keys.  Seems almost  
>> the first
>> thing you do when designing tables is chosing you primary key and  
>> setting
>> the index.
>
> Yes, we know. It's a bug that we want to fix!
>
> I'm not quite sure if it has always been like that or if the problem
> was introduced by the rails port, but it doesn't really matter now.

its a hangover from when all data was in one table per object, now we  
have current_nodes etc...

there shouldn't be primary keys on the nodes, segments and ways  
tables as they have multiple entries from the history, of course.

>
> Tom
>
> -- 
> Tom Hughes (tom at compton.nu)
> http://www.compton.nu/
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
>

have fun,

SteveC | steve at asklater.com | http://www.asklater.com/steve/


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20070623/325314f9/attachment.html>


More information about the dev mailing list