Horton

Re: Fix bug of CHECK constraint enforceability recursion

Álvaro Herrera <alvherre@kurilemu.de>

View thread
From: Álvaro Herrera <alvherre@kurilemu.de>
To: "Chao Li" <li.evan.chao@gmail.com>, "jian he" <jian.universality@gmail.com>
Cc: "L. pgsql-hackers" <pgsql-hackers@lists.postgresql.org>, "Andrew Dunstan" <andrew@dunslane.net>
Date: 2026-05-26T07:32:39Z
Lists: pgsql-hackers 
On 2026-05-26, Chao Li wrote:
>> On May 26, 2026, at 14:05, jian he <jian.universality@gmail.com> wrote:

>> Overall, i tend to think that we should reject ALTER TABLE ALTER
>> CONSTRAINT if it
>> would result in the parent constraint being enforced while the child constraint
>> is not enforced.

Yeah.

> I am not against the idea of "rejecting ALTER TABLE ALTER CONSTRAINT if 
> it would result in the parent constraint being enforced while the child 
> constrain is not enforced", but I’m afraid it’s too late for PG19. So, 
> I guess we still need to fix the issue for 19, right?

I think this is a bug that we need to fix in 19 as well — I mean we should reject the ALTER TABLE.

-- 
Álvaro Herrera