Hello.
> Have anyone an hind for, why this trigger Lock the Table Customer ?? I was unable to reproduce this problem on my ALT Linux system, but I've noticed one server crash during my tests. Please, could you send a reproducible test case. Use the output of SHOW CREATE TABLE to provide exact table definitions. Include the sample data as well. > Is it a problem, that i have not compile the version on my system ? In most case MySQL AB recommends to use official binaries. H$usler Tom <[EMAIL PROTECTED]> wrote: > System Linux SUSE 9.1 with mysql-max-5.0.11-beta-linux-i686.tar.gz > Trigger: > > create trigger CustomerHistoryUPD > BEFORE Update > on Customer > For each ROW BEGIN > insert into CustomerHist select * from Customer where FD_ID = OLD.FD_ID; > Update CustomerHist set HistDate = NOW() where FD_ID = OLD.FD_ID; > END; > > create trigger CustomerHistoryDEL > BEFORE Delete > on Customer > For each ROW BEGIN > insert into CustomerHist select * from Customer where FD_ID = OLD.FD_ID; > Update CustomerHist set HistDate = NOW() where FD_ID = OLD.FD_ID; > END; > > > Have anyone an hind for, why this trigger Lock the Table Customer ?? > Is it a problem, that i have not compile the version on my system ? > > Thanks to all who have a hind form e. > > > > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
