make ALTER DOMAIN VALIDATE CONSTRAINT no-op when constraint is validated
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.
Attachments:
v1-0001-make-ALTER-DOMAIN-VALIDATE-CONSTRAINT-no-op-when-constrai.patchtext/x-patch; charset=US-ASCII; name=v1-0001-make-ALTER-DOMAIN-VALIDATE-CONSTRAINT-no-op-when-constrai.patchDownload+18-14
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.
Attachments:
v2-0001-make-ALTER-DOMAIN-VALIDATE-CONSTRAINT-no-op-when-constraint-is-va.patchtext/x-patch; charset=US-ASCII; name=v2-0001-make-ALTER-DOMAIN-VALIDATE-CONSTRAINT-no-op-when-constraint-is-va.patchDownload+22-20
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