[OSM-dev] Database Schema (was Re: [OSM-talk] Oh dear - planet has duplicate id's)
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
>> 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 Hughes (tom at compton.nu)
> dev mailing list
> dev at openstreetmap.org
SteveC | steve at asklater.com | http://www.asklater.com/steve/
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the dev