"CN" <cnliou9(at)fastmail(dot)fm> writes:
> I notice that PostgreSQL does disable triggers but it seems to not
> disable CHECK constraint:
Why should it?
(Hint: a check constraint that looks at anything but the row being
checked is broken by definition.)
regards, tom lane