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

From Peter Eisentraut
Subject Re: NOT ENFORCED constraint feature
Date
Msg-id cd3e30c3-9763-425f-965a-5817ba91da72@eisentraut.org
Whole thread Raw
In response to Re: NOT ENFORCED constraint feature  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: NOT ENFORCED constraint feature
List pgsql-hackers
On 03.02.25 08:50, Alvaro Herrera wrote:
> On 2025-Feb-03, Ashutosh Bapat wrote:
> 
>> VALID, NOT ENFORCED changed to VALID, ENFORCED - data validation
>> required, constraint is enforced
> There's no such thing as a VALID NOT ENFORCED constraint.  It just
> cannot exist.

The way I interpret this is that the VALID flag is just recording what 
would happen if the constraint was enforced.  So you you take a [NOT] 
VALID ENFORCED constraint and switch it to NOT ENFORCED and back and you 
get back to where you started.



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: NOT ENFORCED constraint feature
Next
From: Peter Eisentraut
Date:
Subject: Re: NOT ENFORCED constraint feature