Brian Wong wrote: > 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? >> > ok, thanks.
> 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 email has been scanned and certified safe by SpammerTrap(tm). For Information please see http://www.spammertrap.com _________________________________________________________________________ ------------------------------------------------------------------------- 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/
