Re: refactor AlterDomainAddConstraint (alter domain add constraint) - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: refactor AlterDomainAddConstraint (alter domain add constraint)
Date
Msg-id 202511261203.r2esjfdh2ldy@alvherre.pgsql
Whole thread Raw
In response to Re: refactor AlterDomainAddConstraint (alter domain add constraint)  (jian he <jian.universality@gmail.com>)
List pgsql-hackers
On 2025-Nov-26, jian he wrote:

> (IMHO, it looks like big efforts to solve the same problem, also these bit
> fiddling for domain constraint unlikely to change in the future, e.g. we are
> unlike to add DEFERRABLE, INITIALLY DEFERRED, NO INHERIT constraints to domain.)

True.

I was thinking we would use the this mechanism to solve the issue for
constraint triggers, but in commit 87251e114967 I did that in a
different way.   I think this one

> this thread: v5-0001-ALTER-DOMAIN-ADD-CONSTRAINT-error-message-enhance.patch

is a reasonable implementation, ugly though it is.  We could handle the
checks for deferrability before calling processCASbits() though.

-- 
Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/
Tom: There seems to be something broken here.
Teodor: I'm in sackcloth and ashes...  Fixed.
                               http://postgr.es/m/482D1632.8010507@sigaev.ru



pgsql-hackers by date:

Previous
From: Kirill Reshke
Date:
Subject: Re: transformJsonFuncExpr pathspec cache lookup failed
Next
From: Álvaro Herrera
Date:
Subject: Re: IPC/MultixactCreation on the Standby server