Additionally, adding an enum value cannot be run in a transaction.

And I use dbmate which puts all migrations in transactions.