On 7/5/07, Michael Scheidell <[EMAIL PROTECTED]> wrote: > In SQL based quarantine, if I run a script to delete quarantined email > after (x) days, but want to keep the LOG entries, what is best to do? > > Just find quarantined chunks and set to ''? Or point id to a phony > (blank) record? > > The former would keep lots of records that are duplicates (blank chunks) > but the later might mess up foreign keys. > > What are you doing? >
If you just delete records from the 'quarantine' table there would be no problem. Because the reference is to the 'msgs' table, not the other way around. ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ 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/
