[osmosis-dev] Two tag keys with different capitalisation

Simon Nuttall simon.nuttall at gmail.com
Tue Dec 1 16:32:26 GMT 2009


I have tracked down a duplicate entry problem to two tag keys that
have the different capitalisation:

 <node id="568478319" version="1" timestamp="2009-11-22T16:29:08Z"
uid="192124" user="Tony0" changeset="3187836" lat="50.6536544"
lon="-3.8970201">
    <tag k="historic" v="archaeological_site"/>
    <tag k="Historic" v="Ruin"/>
    <tag k="name" v="Three Boys"/>
    <tag k="wpt_symbol" v="Dot"/>
  </node>

How should I fix up the table definition (I'm using MySQL) to skip over this?
Currently:

CREATE TABLE  `current_node_tags` (
  `id` bigint(64) NOT NULL,
  `k` varchar(255) NOT NULL default '',
  `v` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`,`k`)
-- ,
--  CONSTRAINT `current_node_tags_ibfk_1` FOREIGN KEY (`id`)
REFERENCES `current_nodes` (`id`)
)

Am I OK to change it from PRIMARY KEY to just KEY ?

Simon




More information about the osmosis-dev mailing list