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 enforcedThere'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.
