Обсуждение: Are check constraints always evaluated on UPDATE?

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

Are check constraints always evaluated on UPDATE?

От
bubba postgres
Дата:
Are there any optimizations around check constraints such that they will not be evaluated if constituent columns are not updated?

Regards,
-JD

Re: Are check constraints always evaluated on UPDATE?

От
Tom Lane
Дата:
bubba postgres <bubba.postgres@gmail.com> writes:
> Are there any optimizations around check constraints such that they will not
> be evaluated if constituent columns are not updated?

Nope.

            regards, tom lane