Approaching Zero: Constraint Changes

This is part six in a series on near-zero downtime deployments. In the last post, we looked at making minimally-blocking changes to tables. Today, we're going to focus on constraints: primary keys, unique keys, foreign keys, default constraints, and check constraints to be precise. Setup Phase For this set of tests, I'm going to create…