Keary Suska <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to