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.
On Tue, May 13, 2025 at 8:57 AM jian he <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.