In v3.5.4 and v3.5.6, I'm running into problems with unexpected constraints being added when I copy an InnoDB database. If I don't check the "Add Constraints" box, the constraints are still added in ...
In PostgreSQL 12+, the best practice for safely adding a NOT NULL constraint to an existing column is to add a check constraint with NOT VALID and then run VALIDATE CONSTRAINT. Explanation by ...