Thread: Re: NOT ENFORCED constraint feature

Re: NOT ENFORCED constraint feature

From
Alvaro Herrera
Date:
On 2025-Jan-31, Ashutosh Bapat wrote:

> But if the constraint is NOT VALID and later marked as NOT ENFORCED,
> what is expected behaviour while changing it to ENFORCED?

I think what you want is a different mode that would be ENFORCED NOT
VALID, which would be an extension of the standard, because the standard
does not support the concept of NOT VALID.  So while I think what you
want is nice, I'm not sure that this patch necessarily must implement
it.

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/