DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=20104>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=20104 [FIX] db2 ddl - unique constraints with nullable columns ------- Additional Comments From [EMAIL PROTECTED] 2003-07-08 14:18 ------- What worked for me was to remove the language and country unique constraints and define media_type and page as NOT NULL. For my situation this was an acceptable level of db-guaranteed uniqueness. (USER_NAME->MEDIA_TYPE->PAGE) will always be unique as USER_NAME (as well as ROLE_NAME and GROUP_NAME) are all forced to be unique by application logic. see http://stumod.com/jetspeed/ for a walkthrough on getting db2 and Jetspeed working together (as of 1.4b5-dev). --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
