List Info

Thread: 8 bind variables when 9 are needed?




8 bind variables when 9 are needed?
user name
2006-05-19 03:13:16
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-userlists.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/
[1]

about | contact  Other archives ( Real Estate discussion Medical topics )