CODEWITHSUNDEEP
javadatabasedatabase-migrationliquibase
idelkaro
idelkaro

Reputation: 37

Adding changes to the old changelog files. Liquibase

I have a lot of changelog files with the initial data for my database. Before all the tables were located in Postgres public schema, but now I have distributed them between different schemas, so that changes with initial data can't reach the tables.

Can I just change all the old files with initial data and add there schemaName="my_schema" or there is another way to solve the problem?

Upvotes: 2

Views: 1035

Answers (2)

gavenkoa
gavenkoa

Reputation: 48933

You could mark a changeset as valid with the updated checksum. It won't be applied if already applied but will stop to complain about checksum mismatch ))

There is even magical hash to ignore any edits: 1:any ))

Upvotes: 0

Daryl Doak
Daryl Doak

Reputation: 244

Once a changeset has been executed, it cannot be modified (assuming runOnChange is not used). If you modify an already executed changeset you will get a checksum error preventing further deployments.

The best option is to create new changesets that contain the updated sql statements.

Upvotes: 3

Related Questions