Re: NOT ENFORCED constraint feature - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: NOT ENFORCED constraint feature
Date
Msg-id 202501311340.knics25bato5@alvherre.pgsql
Whole thread Raw
List pgsql-hackers
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/



pgsql-hackers by date:

Previous
From: Antonin Houska
Date:
Subject: Re: why there is not VACUUM FULL CONCURRENTLY?
Next
From: Jelte Fennema-Nio
Date:
Subject: Commitfest app release on Feb 17 with many improvements