Participants
bubba postgres
bubba postgres
Tom Lane
Tom Lane
Attachments
Show all attachments
Thread Outline
#1bubba postgresbubba postgres
Jun 17, 2011
#2Tom Lane↳Tom Laneto bubba postgres (#1)
Jun 17, 2011

Are check constraints always evaluated on UPDATE?

Started by bubba postgresabout 15 years ago2 messagesgeneral
Jump to latest
#1bubba postgres
bubba postgres
bubba.postgres@gmail.com

Are there any optimizations around check constraints such that they will not
be evaluated if constituent columns are not updated?

Regards,
-JD

#2Tom Lane
Tom Lane
tgl@sss.pgh.pa.us
In reply to: bubba postgres (#1)
Re: Are check constraints always evaluated on UPDATE?

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

← Back to Topics