Open avoronov-box opened 11 months ago
I believe this is okay, there will be some locking when modify a table schema in Postgres. I think as long as the locking is short, it will be okay for a production system.
When adding a null field, Postgres will take almost no time to verify the check constraint, because there aren't any rows with the new column
There's some docs on safely applying migrations to prevent locks from breaking a running application: https://squawkhq.com/docs/safe_migrations
Adding a column with a constraint directly causes the same locking issue as adding a constraint:
Currently
squawk
does not report this as a violation. Would be great to catch this.