Request a Demo
Home   >   mailing lists

Re: make ALTER DOMAIN VALIDATE CONSTRAINT no-op when constraint is validated - Mailing list pgsql-hackers

From jian he
Subject Re: make ALTER DOMAIN VALIDATE CONSTRAINT no-op when constraint is validated
Date
Msg-id CACJufxFCzKNqJGwYFHoXskiGnO-uP7E7kiMn6yeZReJ16dG3mw@mail.gmail.com
Whole thread Raw
In response to make ALTER DOMAIN VALIDATE CONSTRAINT no-op when constraint is validated  (jian he <jian.universality@gmail.com>)
List pgsql-hackers
Tree view 
On Wed, May 21, 2025 at 2:49 PM jian he <jian.universality@gmail.com> wrote:
>
> hi.
>
> Looking at AlterDomainValidateConstraint, it seems currently, ALTER
> DOMAIN VALIDATE
> CONSTRAINT will re-validate a VALID constraint, which
> would just waste cycles.
> Ideally, this operation should be a no-op.
>
> The attached patch addresses this by making ALTER DOMAIN VALIDATE CONSTRAINT a
> no-op in such cases.
>
> ALTER TABLE VALIDATE CONSTRAINT is already a no-op when the constraint is VALID.

hi.

simple rebase.
Attachment

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Adding REPACK [concurrently]
Next
From: Aleksander Alekseev
Date:
Subject: [PATCH] Remove make_temptable_name_n()