Skip to main content

ban-uncommitted-transaction

problem

If you start a transaction and forget to add a commit statement, then the migration will run successfully, but it won't have actually applied the changes.

begin;
create table users (id bigint);
-- missing `commit`!

solution

Add a commit statement to complete your transaction!

begin;
create table users (id bigint);
commit;