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
AMaViS-user lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amav
is.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/ho
wto/
|