Re: make VALIDATE domain constraint lock on related relations as ShareUpdateExclusiveLock

Committed.

Note that the proposed commit message had an example using ALTER TABLE, 
which was not right.  I used an example from your email using ALTER 
DOMAIN instead.


On 13.05.25 11:34, wenhui qiu wrote:
> HI
>     Thanks for the patch! and overall this is a valuable improvement in 
> terms of concurrency and consistency with table-level behavior.The 
> refactoring to pass LOCK MODE into validateDomainCheckConstraint() 
> improves flexibility and clarity. and the patch also looks good to me.
> 
> 
> Regards
> 
> On Tue, May 13, 2025 at 2:23 PM Dilip Kumar <dilipbalaut@gmail.com 
> <mailto:dilipbalaut@gmail.com>> wrote:
> 
>     On Tue, May 13, 2025 at 8:57 AM jian he <jian.universality@gmail.com
>     <mailto:jian.universality@gmail.com>> wrote:
>      >
>      > hi.
>      >
>      > We can still perform DML operations on a table while validating its
>      > check constraint.
>      > Similarly, it should be fine to do DML while validating domain
>     constraints?
>      > but currently, it's not allowed for domain constraints.
>      >
>      > The attached patch addresses this problem.
> 
>     This makes sense, and the patch also looks good to me.
> 
>     -- 
>     Regards,
>     Dilip Kumar
>     EnterpriseDB: http://www.enterprisedb.com <http://www.enterprisedb.com>
> 
>