replace TRUNCATE with DELETE FROM to avoid schema changes within transaction
diff --git a/database/cockroachdb/cockroachdb.go b/database/cockroachdb/cockroachdb.go
index 8da31d3..50ae8f4 100644
--- a/database/cockroachdb/cockroachdb.go
+++ b/database/cockroachdb/cockroachdb.go
@@ -223,7 +223,7 @@
func (c *CockroachDb) SetVersion(version int, dirty bool) error {
return crdb.ExecuteTx(context.Background(), c.db, nil, func(tx *sql.Tx) error {
- if _, err := tx.Exec( `TRUNCATE "` + c.config.MigrationsTable + `"`); err != nil {
+ if _, err := tx.Exec(`DELETE FROM "` + c.config.MigrationsTable + `"`); err != nil {
return err
}