Обсуждение: make ALTER DOMAIN VALIDATE CONSTRAINT no-op when constraint is validated

Поиск
Список
Период
Сортировка

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

От
jian he
Дата:
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.
Вложения

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

От
jian he
Дата:
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.
Вложения