Postgres Pro
Downloads
Home   >   mailing lists

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

From bubba postgres
Subject Are check constraints always evaluated on UPDATE?
Date
Msg-id BANLkTim8FD8yBH8EUFZcJUe6VO90xX+HDQ@mail.gmail.com
Whole thread Raw
Responses Re: Are check constraints always evaluated on UPDATE?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
Are there any optimizations around check constraints such that they will not be evaluated if constituent columns are not updated?

Regards,
-JD

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: 2 questions re RAID
Next
From: Tom Lane
Date:
Subject: Re: Are check constraints always evaluated on UPDATE?