On 7/5/07, Michael Scheidell <[EMAIL PROTECTED]> wrote: > Brian Wong wrote: > > 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. > > > > if you then 'clean out logs' (ie, delete records from msgs table every > 90 days) won't it be missing a key and mess up foreign key constraints? >
I think you are misunderstanding how it works. The dependence is unidirectional. If you delete the record from a 'msgs' table, the corresponding record in the 'quarantine' table will be removed. If you delete just the record in the 'quarantine' table, that will be the only table affected. The process of deleting a record from the 'msgs' table will check for any references to it. It will delete those that are referenced to it, but the lack of the reference will not throw an error. ------------------------------------------------------------------------- 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/
