Hi!

On my new project I finally started using Mojo::Pg::Migrations but ran into a problem.

All migrations are wrapped within transactions. But some schema changes, such as enum type modifications can not be run inside transactions.

And code falls with message

DBD::Pg::st execute failed: ERROR:  ALTER TYPE ... ADD cannot run inside a transaction block at /path/to/project/local/lib/perl5/Mojo/Pg/Migrations.pm line 66

As I can see, for now there is no way to disable transaction for some migrations.

So, what do you think, is it a good feature?

Other frameworks, such as rails and laravel implemented this due to the same idea,

https://github.com/laravel/framework/pull/22757

https://github.com/rails/rails/pull/9507

--

Best regards

Ilya Rassadin.

--
You received this message because you are subscribed to the Google Groups 
"Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.

Reply via email to