Trigger Lock table

[Häusler Tom]

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.

 




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]