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

From: Dilip Kumar <dilipbalaut(at)gmail(dot)com>
To: jian he <jian(dot)universality(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: make VALIDATE domain constraint lock on related relations as ShareUpdateExclusiveLock
Date: 2025-05-13 06:22:47
Message-ID: CAFiTN-uED9R1ZBNYSNx4ef3mQSuoRVUeSapxyL_hVZ-zs-t+Eg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Guo 2025-05-13 08:02:54 Add explicit initialization for all PlannerGlobal fields
Previous Message Laurenz Albe 2025-05-13 06:05:24 Re: PG 18 release notes draft committed