Postgres Pro
Downloads
Home   >   mailing lists

Thread: Are check constraints always evaluated on UPDATE?

Are check constraints always evaluated on UPDATE?

From
bubba postgres
Date:
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?

From
Tom Lane
Date:
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