Comments
Sort by recent activity
Hi Vlad, Unfortunately, Flyway itself cannot change how PostgreSQL handles DDL locking. The ALTER TABLE ADD COLUMN command in Postgres requires an ACCESS EXCLUSIVE lock, which blocks read and writes to the table until the statement completes. This is a PostgreSQL behavior, not something Flyway can override. To change this, you could change the DDL statements, but that would require manual change. You're correct in your assumption, that property only affects its own flyway_schema_history table. / comments
Official comment
Hi Vlad,Unfortunately, Flyway itself cannot change how PostgreSQL handles DDL locking.The ALTER TABLE ADD COLUMN command in Postgres requires an ACCESS EXCLUSIVE lock, which blocks read and writes ...