Thread: table constraint or trigger?

table constraint or trigger?

From
Andreas Fromm
Date:
Hi,

I have a situation where I could impose a constraint by a rather
complicatet CHECK table constraint, or I could define an ON INSERT OR
UPDATE trigger that would abort the transaction if the validation
doesn't succeed. Is there any advise in favor of one of the solutions?

Regards

Andreas