Re: Fix bug of CHECK constraint enforceability recursion - Mailing list pgsql-hackers

From Álvaro Herrera
Subject Re: Fix bug of CHECK constraint enforceability recursion
Date
Msg-id cb4a41fd-67e8-47ed-bcff-d0549dce3f02@app.fastmail.com
Whole thread
Responses Re: Fix bug of CHECK constraint enforceability recursion
List 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



pgsql-hackers by date:

Previous
From: "Jelte Fennema-Nio"
Date:
Subject: Re: libpq maligning postgres stability
Next
From: Chao Li
Date:
Subject: Re: Fix bug of CHECK constraint enforceability recursion