Hey guys ,
I have a change set like the following
<changeSet author="me" id="2009-03-09-3345-2">
<preConditions onFail="MARK_RAN">
<dbms type="oracle"/>
</preConditions>
<comment>Create a sequence/trigger oracle</comment>
<createSequence sequenceName="TEST_ID_SEQ"/>
<sql splitStatements="false"> create or replace trigger test_bef_trg
before insert on test
...</sql>
<rollback>drop trigger test_bef_trg</rollback>
</changeSet>
Now if we run an update on a Postgres DB this changeset will not run yet a
row will be added to changeLogDatabase. Now the problem happens when we do a
rollback, The rollback actually runs in Postgres and causing an error as
expected. Shouldn't the rollback not run ? It does not seem to be looking at
the preCondition.
One solution would be to change onFail to Mark ran, but I do want a
consistent number of rown in the changeLogDatabase in both dbs.
Thank you
--
View this message in context:
http://www.nabble.com/Rolling-back-a-changeSet-which-has-a-preCondition-set-to-MARK_RAN-tp22722117p22722117.html
Sent from the LiquiBase - User mailing list archive at Nabble.com.
------------------------------------------------------------------------------
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
