[wp-trac] [WordPress Trac] #10905: Do not allow duplicate (post_id, meta_key, meta_value) rows in meta tables

[WordPress Trac]

#10905: Do not allow duplicate (post_id, meta_key, meta_value) rows in meta tables
--------------------------+-------------------------------------------------
 Reporter:  scribu        |       Owner:  ryan          
     Type:  defect (bug)  |      Status:  new           
 Priority:  normal        |   Milestone:  Future Release
Component:  Database      |     Version:  2.9           
 Severity:  normal        |    Keywords:  needs-patch   
--------------------------+-------------------------------------------------

Comment(by mrmist):

 Nope, but it's the only way to index such columns.

 The alternative (to the index) I guess is to introduce a check before such
 a row is inserted or updated, to see if it would produce a duplicate.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/10905#comment:13>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software