cross-table business validation check at END of transaction

[Greg Hauptmann]

Hi,

Is it possible in mysql to implement a cross-table Business Rule check that is applied whenever a record changes in any of tables involved, BUT only have the check occur just prior to the overall database COMMIT?

That is, within the transaction there would be record changes going on that in themselves may cause the business rule to break, but by the time all is done and the commit comes along (in this case from Ruby on Rails) THEN apply the cross table check (e.g. sum to totals in Table X linked to Table Y should be equal, or something like that), and if it doesn't pass trigger a rollback & exception.

Thanks in advance
Greg