From: | David Rowley <dgrowleyml(at)gmail(dot)com> |
---|---|
To: | Erki Eessaar <erki(dot)eessaar(at)taltech(dot)ee> |
Cc: | "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Potential bug: Enforcing/not enforcing a CHECK constraint fails on an empty table |
Date: | 2025-10-01 05:24:52 |
Message-ID: | CAApHDvrNaOx4stGRVO=4=7GMHhpg+e6g-Gh9us+Mqx=YoZB0Cg@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Wed, 1 Oct 2025 at 01:12, Erki Eessaar <erki(dot)eessaar(at)taltech(dot)ee> wrote:
> However, the inconsistency I'm pointing out is that this "documentation-only" state appears to be modifiable for FOREIGN KEY constraints (using ALTER TABLE ... ENFORCED), but not for CHECK constraints.
>
> This leads to the core of my question: Is this difference in behavior intentional?
At least going by the commit messages, it seems to be intentional:
From [1]:
Note that CHECK constraints do not currently support ALTER operations,
so changing the enforceability of an existing constraint isn't
possible without dropping and recreating it. This could be added
later.
And for foreign keys in [2]:
Conversely, if a NOT ENFORCED
foreign key constraint is changed to ENFORCED, the necessary triggers
will be created, and the will be changed to VALID by performing
necessary validation.
> If NOT ENFORCED constraints are not meant to be altered after creation, then it seems the ability to enforce a foreign key is the unexpected behavior. If they are meant to be alterable, then the failure to enforce a check constraint seems to be the bug.
I think it would be good if the documents were to mention the
limitation with CHECK constraints. Otherwise, users are just going to
be left to discover this for themselves.
David
[1] https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=ca87c415e
[2] https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=eec0040c4
From | Date | Subject | |
---|---|---|---|
Next Message | Virender Singla | 2025-10-01 09:32:21 | Revoke role membership does not remove cascade privileges |
Previous Message | Tom Lane | 2025-09-30 15:29:51 | Re: Cast to regrole on a literal string in a PL/pgSQL function |