PostgreSQL Constraint Naming Convention: Which Pattern to Use, and How to Find the Names That Drifted

Schemity's guide to naming Postgres constraints and indexes: the pattern to pick, the 63-byte cut that makes two names collide, and a query for stale...