Activity overview
Latest activity by gulesin
Yeah, your understanding is right. Flyway can’t change the lock mode PostgreSQL uses for ALTER TABLE; that part is controlled by PostgreSQL itself. The transactional-lock setting is about Flyway’s own advisory lock for coordinating migrations, not the ACCESS EXCLUSIVE lock taken by the DDL. For a busy production table, I’d keep the migration as short as possible and consider setting a small lock_timeout so the migration fails instead of sitting there waiting and blocking traffic. For larger schema changes, an expand/contract approach is usually safer. / comments
Yeah, your understanding is right. Flyway can’t change the lock mode PostgreSQL uses for ALTER TABLE; that part is controlled by PostgreSQL itself. The transactional-lock setting is about Flyway’s ...
perfect thanks / comments
perfect thanks