Trying to update an existing SQL function, the SQL code is correct (have run it directly on the database) but cannot get Liquibase to run it successfully, or roll it back
Liquibase says âMigration Successfulâ on update but nothing is changed in the DB, and âMigration Failed: Unknown Reasonâ on rollback.
<?xml version="1.0" encoding="UTF-8"?> http://www.liquibase.org/xml/ns/dbchangelog/1.7" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog/1.7 http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.7.xsd"> DROP FUNCTION dummy(text, text, text); CREATE OR REPLACE FUNCTION dummy(var1 text, var2 text, var3 text, newvar1 text) RETURNS void AS $BODY$*/ RETURN; END; $BODY$ LANGUAGE 'plpgsql' VOLATILE; ALTER FUNCTION dummy(text, text, text, text) OWNER TO bob; DROP FUNCTION dummy(text, text, text, text); CREATE OR REPLACE FUNCTION dummy(var1 text, var2 text, var3 text) RETURNS void AS $BODY$ /*RETURN; END; $BODY$ LANGUAGE âplpgsqlâ VOLATILE; ALTER FUNCTION dummy(text, text, text) OWNER TO bob;