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

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(at)gmail(dot)com> wrote:

> On Tue, May 13, 2025 at 8:57 AM jian he <jian(dot)universality(at)gmail(dot)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
>
>
>