[wp-trac] [WordPress Trac] #14513: Time for a wp_post_relationships table?

[WordPress Trac]

#14513: Time for a wp_post_relationships table?
-----------------------------+----------------------------------------------
 Reporter:  mikeschinkel     |        Owner:                
     Type:  feature request  |       Status:  reopened      
 Priority:  normal           |    Milestone:  Future Release
Component:  Post Types       |      Version:  3.0.1         
 Severity:  normal           |   Resolution:                
 Keywords:                   |  
-----------------------------+----------------------------------------------

Comment(by mikeschinkel):

 Replying to [comment:19 nacin]:
 > > The problem I have been running into is ensuring that adding of a
 > > term doesn't fail because of a pre-existing slug that has been added
 for a
 > > post tag.
 >
 > While not exactly intuitive via the existing APIs, it's entirely
 possible to add a term_taxonomy relationship that uses the term object as
 a post tag, thus the same slug, etc. Terms (as defined by the schema) can
 exist in more than one taxonomy.

 Yes, but then if I edit the mirrored post's title and automatically update
 the term's name and slug it modifies the term for the post tag too (the
 user requirement is, by definition that the two remain in-sync.) Clearly
 changing the post_tag would be an undesirable side effect, no?

 I guess we could run code to create a new term and update all
 `wp_term_taxonomy` records that use the term as a tag but that's starting
 to feel more and more kludgy; what if that update fails for some reason?
 Yes we can code referential integrity in PHP but the more we do it in
 increasingly complex ways the more we are asking for corrupted user data
 and yes, disenchanted users.

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