Request a Demo
Home   >   mailing lists

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

From Peter Eisentraut
Subject Re: make ALTER DOMAIN VALIDATE CONSTRAINT no-op when constraint is validated
Date
Msg-id 2928cd90-909b-486a-bf72-51fbb9620236@eisentraut.org
Whole thread Raw
In response to Re: make ALTER DOMAIN VALIDATE CONSTRAINT no-op when constraint is validated  (jian he <jian.universality@gmail.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Anthonin Bonnefoy
Date:
Subject: Re: Shutdown indefinitely stuck due to unflushed FPI_FOR_HINT record
Next
From: Jakub Wartak
Date:
Subject: Re: Add errdetail() with PID and UID about source of termination signal