Postgres Pro
Downloads
Home   >   mailing lists

Re: make VALIDATE domain constraint lock on related relations as ShareUpdateExclusiveLock - Mailing list pgsql-hackers

From Dilip Kumar
Subject Re: make VALIDATE domain constraint lock on related relations as ShareUpdateExclusiveLock
Date
Msg-id CAFiTN-uED9R1ZBNYSNx4ef3mQSuoRVUeSapxyL_hVZ-zs-t+Eg@mail.gmail.com
Whole thread Raw
In response to make VALIDATE domain constraint lock on related relations as ShareUpdateExclusiveLock  (jian he <jian.universality@gmail.com>)
List pgsql-hackers
Tree view 
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.

--
Regards,
Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: PG 18 release notes draft committed
Next
From: Richard Guo
Date:
Subject: Add explicit initialization for all PlannerGlobal fields