Обсуждение: table constraint or trigger?

Поиск
Список
Период
Сортировка

table constraint or trigger?

От
Andreas Fromm
Дата:
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