[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