Re: Are check constraints always evaluated on UPDATE? - Mailing list pgsql-general

From Tom Lane
Subject Re: Are check constraints always evaluated on UPDATE?
Date
Msg-id 26713.1308347241@sss.pgh.pa.us
Whole thread Raw
In response to Are check constraints always evaluated on UPDATE?  (bubba postgres <bubba.postgres@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: bubba postgres
Date:
Subject: Are check constraints always evaluated on UPDATE?
Next
From: "Leon Match"
Date:
Subject: merge in postgres trigger function