> > Hopefully the last release candidate before the final release: I guess not, here is the next one, sorry:
http://www.ijs.si/software/amavisd/amavisd-new-2.4.0-rc6.tar.gz From Brian Wong: > It is probably too late to bring up, but instead of adding a > 'time_num' column to 'msgrcpt' and 'quarantine' tables, why not have > the records in these two tables reference the 'msgs' table using the > 'mail_id' as a foreign key? This will enforce the integrity of the > relationship and will also make purging easier with 'DELETE FROM ... > CASCADE'. Something I am missing? Thanks. There is always time to teach old dog new tricks :) If using SQL logging or quarantine please see if you like the new FOREIGN KEY constraing and the simplifications it puts to database purging better than the time_num filed that was used in pre-release and RC version of 2.4.0 so far. The change is documented in the beginning of RELEASE_NOTES and also in README.sql. If there will be a grand objection, I'll put the time_num back in tables msgrcpt and quarantine tables, although having these two fields indexed imposes additional burden on inserts and deletes. Besides the above, it fixes few per-recip macro values when $log_recip_templ is in use for better per-recip logging, and makes $sa_timeout somewhat redundant. Mark ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
