Are triggers a reliable way of maintaining summary tables? I have an
orders table, where with every insert/delete/update, I need to update a
summary table, possibly via a trigger e.g. UPDATE summary_table SET
quantity = quantity + :NEW.quantity WHERE item_id = x

Are there any possible locking issues, or trigger failure scenarios?
Thanks for any help.

Regards
Ray Mond