#990: RelatedJoin nXn table should have an option for uniqueness
-----------------------+----------------------------------------------------
Reporter: anonymous | Owner: anonymous
Type: defect | Status: new
Priority: normal | Milestone:
Component: SQLObject | Version: 0.9a6
Severity: normal | Keywords:
-----------------------+----------------------------------------------------
n-to-n relationship intermediate tables created automatically by
RelatedJoin, have no database-level protection against multiple rows that
link the end tables. There should be an option (whose default IMHO should
be True) that cretes a compound UNIQUE INDEX with the two IDs.
Another 'bug', in my opinion, is that the intermediate table is created
without any indexes. If the unique compount index suggested above is not
created, at least one of the table rows should have an index, or add an
option to do so.
--
Ticket URL: <http://trac.turbogears.org/turbogears/ticket/990>
TurboGears <http://www.turbogears.org/>
TurboGears front-to-back web development
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears Tickets" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/turbogears-tickets
-~----------~----~----~----~------~----~------~--~---