Re: alter check constraint enforceability

jian he <jian.universality@gmail.com>

From: jian he <jian.universality@gmail.com>

To: PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2025-07-04T11:59:47Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Add support for altering CHECK constraint enforceability
- 342051d73b38 19 (unreleased) landed
rename alter constraint enforceability related functions
- a9747153e14d 19 (unreleased) landed

Attachments

v2-0001-alter-check-constraint-enforceability.patch (text/x-patch) patch v2-0001

On Mon, Jun 2, 2025 at 9:57 PM jian he <jian.universality@gmail.com> wrote:
>
> Currently in pg18, we can add not enforced check constraints.
> but we can not do  ALTER TABLE ALTER CONSTRAINT [NOT] ENFORCED
> for check constraint.
>
> The attached patch is implementation of changing enforceability of
> check constraint.

hi.
rebase and minor refactoring.