Question, if Liquibase will be able to understand that the Custom SQL is changed (for example a Custom SQL for the creation of a function) and will change the specific Custom SQL for the new one.
I will clarify about "if liquibase will be able to understand that the custom SQL is changed".
According to my understanding the main benefit of liquibase is automatic upgrade. I just need to create a Changelog File and liquibase will update my schema.
My question what will happens if my Changelog File will contain the tag?
For example, if I created the following rule using the tag:
CREATE OR REPLACE RULE my_delete_rule AS ON DELETE TO my_view
DO INSTEAD
type = 'original' ;
Then, I will change the rule to the following:
CREATE OR REPLACE RULE my_delete_rule AS ON DELETE TO my_view
DO INSTEAD
type = 'new' ;
Will liquibase understand that it is required to change my_delete_rule and will update my schema?
Do you know if somebody already implemented the complex database using liquibase?
When you create liquibase chagneSets, the normal usage is to not go back and modify existing changeSets, but rather to add a new changeSet that takes what has already ran and modify that. It uses the id/author/filename combination to track which changesets have ran, and if you modify an already ran changeSet it will throw an exception (we store a checksum of the changeset in the database)