Re: UPDATE run check constraints for affected columns only

On Sat, Mar 7, 2026 at 5:46 PM jian he <jian(dot)universality(at)gmail(dot)com> wrote:
>
> OK. I kept these tests. I think covering this scenario is useful. Perhaps it
> has already been tested elsewhere, but including it here makes the tests more
> complete
>

+SET log_statement to NONE;
+SET client_min_messages TO 'debug1';
+
+-- constraint cc contain whole-row reference therefore cannot be skipped
+UPDATE upd_check_skip0 SET a = 2;

In V7, setting client_min_messages to capture DEBUG1 messages in
regression tests is not a good idea, as other messages may also be
emitted.
So I added some tests on test/modules/test_misc/t/001_constraint_validation.pl.

I also made some cosmetic changes to make ExecRelCheck more readable.

--
jian
https://www.enterprisedb.com/