Support repetable migration

[asv]

In some cases would be convient to migrate not by creating new migration, but by updating an existing one (for example, for update stored procedure / triggers). Flyway, from-JVM-world migration tool, has this feature (https://flywaydb.org/getstarted/repeatable). Are there plans to add this feature to goose, or a workaround for such case?

[VojtechVitek]

This is not supported by goose.

However, you can easily copy/paste your migration file and run it again, ie. git mv 0001_rerun.sql 0009_rerun.sql should work just fine.

[caseybcessnun]

Has this feature been added since 2019? Is it being considered? This is ABSOLUTELY a feature I'd appreciate seeing. This would allow change tracking via SCM to track changes to the PRC over time, vs having to look back through all past migrations.

[mfridman]

No, it has not been added.

But we did add a -no-versioning flag that enables you to apply migrations over and over without tracking them in the database. Afaics, this is effectively repeatable migrations.

There's a bit more details on how that works here: https://pressly.github.io/goose/blog/2021/no-version-migrations/