My argument was based on the use of triggers to implement business logic and to do the sort of data integrity checking that should be enforced by keys and constraints. I should have made that a bitmore explicit.
Cheers,
Tony.
That was an inappropriate use of triggers from the very beginning.
It was a "legacy" from the day triggers were introduced.
The closest point where triggers should be coming to constraints is preventing run-time errors when a constraint is violated by some change in data and divert the data set causing such a violation to some "data revision" process.
_____________
Code for TallyGenerator