Re: UPDATE run check constraints for affected columns only

From:	jian he <jian(dot)universality(at)gmail(dot)com>
To:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:	PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: UPDATE run check constraints for affected columns only
Date:	2026-03-05 03:12:04
Message-ID:	CACJufxH0oh7YHFZH1MWqgQUdRQ3M8B5yKgzyyDDnLFtc7E1L6Q@mail.gmail.com
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2025-12-01 06:20:32 from jian he <jian(dot)universality(at)gmail(dot)com> 📎  2025-12-01 06:33:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2025-12-01 09:24:11 from li carol <carol(dot)li2025(at)outlook(dot)com>   2025-12-07 15:50:37 from jian he <jian(dot)universality(at)gmail(dot)com> 📎    2026-01-23 02:09:27 from jian he <jian(dot)universality(at)gmail(dot)com> 📎     2026-03-04 01:04:49 from jian he <jian(dot)universality(at)gmail(dot)com> 📎      2026-03-05 03:12:04 from jian he <jian(dot)universality(at)gmail(dot)com> 📎       2026-03-06 02:17:35 from jian he <jian(dot)universality(at)gmail(dot)com> 📎        2026-03-06 16:10:33 from Florin Irion <irionr(at)gmail(dot)com>         2026-03-07 09:46:23 from jian he <jian(dot)universality(at)gmail(dot)com> 📎
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v5-0001-skip-unnecessary-check-constraint-verification-for-UPDATE.patch	text/x-patch	14.9 KB

In response to

• Re: UPDATE run check constraints for affected columns only at 2026-03-04 01:04:49 from jian he

Responses

• Re: UPDATE run check constraints for affected columns only at 2026-03-06 02:17:35 from jian he

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	wenhui qiu	2026-03-05 03:40:13	Re: Convert NOT IN sublinks to anti-joins when safe
Previous Message	Fujii Masao	2026-03-05 03:10:50	Re: Options to control remote transactions’ access/deferrable modes in postgres_fdw