Can't update table XXX in stored function/trigger because it is already used

[Michael Gardner]

Hello,

I have a table, "customers", that holds customer information. The table has a column named, "RowVersion", which is an Int64 and is used for concurrency checking. What I want to do is update RowVersion after an insert or update operation. When I implemented the following triggers, I receive this error:

Error Code: 1442. Can't update table customers in stored function/trigger because it is already used by statement which invoked this stored function/trigger.

So, it appears that I am doing somthing wrong with respect to triggers and my goals. I am sure that a lot of people are implementing row counters for concurrency, but I could not find anything in my searching. I'd appreciate your help in figuring out this issue.

CREATE TRIGGER 'CustomersInsertIncrementRowVersion' AFTER INSERT ON 'customers'
FOR EACH ROW
BEGIN
UPDATE customers set RowVersion = RowVersion + 1 where CustomerId = NEW.CustomerId
END

CREATE TRIGGER 'CustomersUpdateIncrementRowVersion' AFTER UPDATE ON 'customers'
FOR EACH ROW
BEGIN
UPDATE customers set RowVersion = RowVersion + 1 where CustomerId = OLD.CustomerId
END

Thanks,
Mike