3 ms·
if you add a check constraint to an existing table only new/updated records are checked. Existing records will not be checked
by oliverrice 4y ago
if you add a check constraint to an existing table only new/updated records are checked. Existing records will not be checked
- mjw1007 4y agoWhat you describe is not the default behaviour with PostgreSQL (though it is available, via ALTER TABLE ADD CONSTRAINT ... NOT VALID).