Can't toggle DDL Transactions selectively for individual migrations

[tiagonbotelho]

I'm submitting a...

• Bug report
• Feature request
• Question

Current behavior

At the moment we seem to need to use a --non-transactional flag in order to be able to disable DDL transactions from running on a migration. However, it seems that if we only want to do this for a specific migration and not the entire suite, that currently isn't possible.

Expected behavior

Similar to Rails ActiveRecord disable_ddl_transaction! it should be possible to disable the DDL transaction from a specific migration without affecting the entire suite

Environment

db-migrate version: 0.11.3
plugins with versions: `db-migrate-pg` 1.2.2

[wzrdtales]

yes correct, this is not currently possible. The only ugly work around is issuing a stop to the transaction at the beginning and begin a new at the end of your migration.

[tiagonbotelho]

@wzrdtales thank you for your response, do you happen to know if this would be something that could ever be prioritised to make its way into the package by any chance? 😊

[wzrdtales]

PRs are always welcome if you want to give it a shot :)

This feature request in general would probably not be prioritised very soon. The only other alternative would be a payed feature request, should that be business critical to you/your company.