Allow to disable transactional migrations per migration

[User4martin]

Is there a way to disable transactions for individual migrations?

postgresql does not allow
CREATE INDEX CONCURRENTLY
when in a transaction.

So if one wants to use this, one has to run this migration without transaction.

---

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

[wzrdtales]

@User4martin Not directy. You can just disable them at all.

But you can call db.endMigration, which will commit the current transaction. Not sure if postgres is able to handle this properly (commiting an empty or non existent transaction), at least MariaDB/MySQL would allow you to do this without a problem. Try this, but I will also take this issue as a feature request.

[User4martin]

db.endMigration works for postgresql.

Another statement that does not work in transaction is
ALTER TYPE foo ADD VALUE IF NOT EXISTS 'bar' AFTER 'xyz';

[LinusU]

It would be very useful if we could set export.skipTransaction = true or similar to avoid the transaction...

As User4martin said you cannot currently have a postgres migration that adds a value to an enum

[sanketrelfor]

@wzrdtales It would really help the community if you provide the support for disabling a transaction for particular migration. We are facing similar issue reported by @User4martin for Type Alteration. We are using Postgres Database.

[wzrdtales]

I renamed this issue, as it confused me, just thought that was a driver issue 😂

However, you can already, but just in a nasty way. You would need to call commit transaction before executing your actions and at the end call start transaction so that it does not fail when it walks out the migration.

This is on the list of features, if you really need this you have several options, either do it yourself and open a PR, set bounty on it, so someone works on it, vote for it to raise priority or simply wait until it gets added. I will add it definitely but can't tell you right now when exactly. If you would be willing to work on a PR that would be more than welcome 😍