Horton

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

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: a99c6b56ffa74dae49e6847cc6c113d000c8ebd0
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2026-02-24T09:58:36Z
Releases: 19 (unreleased) 
Make ALTER DOMAIN VALIDATE CONSTRAINT no-op when constraint is already validated

Currently, AlterDomainValidateConstraint will re-validate a constraint
that has already been validated, which would just waste cycles.  This
operation should be a no-op when the constraint is already validated.
This also aligns with ATExecValidateConstraint.

Author: jian he <jian.universality@gmail.com>
Discussion: https://postgr.es/m/CACJufxG=-Dv9fPJHqkA9c-wGZ2dDOWOXSp-X-0K_G7r-DgaASw@mail.gmail.com

Files

PathChange+/−
src/backend/commands/typecmds.c modified +25 −19

Discussion