[OSM-dev] way 7062297, is this new?

Stefan de Konink stefan at konink.de
Thu Oct 9 03:27:12 BST 2008


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

Ian Dees schreef:
> On Wed, Oct 8, 2008 at 9:16 PM, Stefan de Konink <stefan at konink.de
> <mailto:stefan at konink.de>> wrote:
> 
> 
>     It is even my primary key {wayid, k}. If you can explain me how a
>     k='name' can ever have a duplicate that is meaningful, please
>     enlighten me.
> 
> 
> Why do you include the tag's key with the primary key? The only primary
> key for a way should be the way's id number. You could also have a
> geospatial key for the lat/lon, but it doesn't make sense to have the
> tag be part of the database's primary key.

It is effectively the same as placing an unique on the wayid/k.

I have a way table, that has a primary key {wayid}. The table way_tags
point to that wayid.


Stefan

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEAREKAAYFAkjtbAAACgkQYH1+F2Rqwn2howCfcgohxwTLO+vVb6mJ/Pi5oG0x
OzIAniu7lwMQDI0nLSvvfFz5bkDGhpoI
=y0WJ
-----END PGP SIGNATURE-----




More information about the dev mailing list