Mark Martinec said the following on 5/18/2006 8:52 PM:
> ALTER TABLE msgs ADD quar_loc varchar(255) DEFAULT '';
>
> The following clause should preferably be executed to take advantage
> of the ON DELETE CASCADE:
>
> ALTER TABLE msgrcpt
> ADD FOREIGN KEY (mail_id) REFERENCES msgs(mail_id) ON DELETE CASCADE;
> ALTER TABLE quarantine
> ADD FOREIGN KEY (mail_id) REFERENCES msgs(mail_id) ON DELETE CASCADE;
>
> See updated suggested set of DELETE clauses at the end of README.sql.
Got these done (Turns out the last two just took foreeeeever to run! :-)
I also ran the maintenance clauses at the end of README.sql, and will
script those so they happen regularly.)
Even after all this (and resetting the ins_msg & ins_rcp back to what
was in the -defaults file), still getting the same error. :-(
Thanks again for your help, I do appreciate it...
Best,
--Glenn
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
~Benjamin Franklin, Historical Review of Pennsylvania, 1759
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
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/
