Horton

Thread

Commits

  1. Make ALTER DOMAIN VALIDATE CONSTRAINT no-op when constraint is already validated

  1. make ALTER DOMAIN VALIDATE CONSTRAINT no-op when constraint is validated

    jian he <jian.universality@gmail.com> — 2025-05-21T06:49:33Z

    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.

  2. Re: make ALTER DOMAIN VALIDATE CONSTRAINT no-op when constraint is validated

    jian he <jian.universality@gmail.com> — 2025-10-10T14:42:42Z

    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.

  3. Re: make ALTER DOMAIN VALIDATE CONSTRAINT no-op when constraint is validated

    Peter Eisentraut <peter@eisentraut.org> — 2026-02-24T10:05:11Z

    On 10.10.25 16:42, jian he wrote:
> On Wed, May 21, 2025 at 2:49 PM jian he <jian.universality@gmail.com> wrote:
>> 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.

committed