Adding a NULL constraint isn't zero downtime since PG scans the whole table ensuring that the constraint is not violated.