Keary Suska <hierophant@pcisys.net> writes:
> It appears that Postgres checks column CHECK constraints when performing an
> update regardless of whether the particular column is being updated.
I believe that's true...
> Perhaps my understanding of column vs table constraints is incomplete
> but this doesn't seem to be proper behavior,
Why not? A constraint is a constraint, it should be valid whenever one
checks it.
regards, tom lane