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 <dilipbal...@gmail.com> wrote: > On Tue, May 13, 2025 at 8:57 AM jian he <jian.universal...@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 > > >