Issue status update for http://drupal.org/node/19399 Project: Drupal Version: cvs Component: database system Category: bug reports Priority: normal Assigned to: Anonymous Reported by: timothy bennett Updated by: timothy bennett Status: by design Agreed. Mea culpa. Based on your comments, I dug deeper into my term_node table and I actually had several duplicate tid-nid pairs. Not sure how that happened... timothy bennett Previous comments: ------------------------------------------------------------------------ March 24, 2005 - 20:28 : timothy bennett Commit# 14491 modifies the term_node table to make both tid and nid primary keys. That is, ALTER TABLE term_node ADD PRIMARY KEY (tid,nid); However, I've got nodes (as referenced by nid) that have multiple taxonomy terms associated with them (as reference by tid). As such, the node_term table with have duplicate entries of nid, one for each term (tid) that the node is associated with. I don't believe you can make a column a primary key if the values are not unique can you? (Ref: http://drupal.org/node/19275) -- timothy ------------------------------------------------------------------------ March 24, 2005 - 20:36 : chx It's a multiple column PRIMARY KEY and it will apply unless you have the same nid-tid pair twice which shall not happen... ------------------------------------------------------------------------ March 24, 2005 - 20:43 : Goba Not a bug.