Leonel Nunez wrote: > to migrate from 2.0.6 to 2.0.7 > Is there a script to add the ON UPDATE CASCADE for PostgreSQL or > we have to look at the create scripts to see those ALTERS :) > > or does not matter if those ON UPDATE CASCADE are not updated
Those ON UPDATE CASCADE-s where added for completions sake. I found out that while migrating to ldap in 2.1 I needed to set the user_idnr in dbmail_users to values that matched the ldap tree. Without the ON UPDATE CASCADE that is very difficult. For normal operation they are not needed at all, but with them you can: UPDATE dbmail_users SET user_idnr = <NEWVALUE> WHERE user_idnr = <OLDVALUE>; and all underlying records (mailbox_idnr, subscriptions, etc) are updated accordingly on the fly. -- ________________________________________________________________ Paul Stevens mailto:[EMAIL PROTECTED] NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED] The Netherlands________________________________http://www.nfg.nl
