X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=sql%2Fbase%2Fbase.sql;h=f7744f15033cd6997d2ef63bf626ec18ff3a10dc;hp=82a7e7a55a5f5e76921a51b498e6e337168c80c7;hb=6e1602827c12879febdcf4e20714ca4e184f8352;hpb=2ad87814f6d7bc908051e184ff538e493126b9fe diff --git a/sql/base/base.sql b/sql/base/base.sql index 82a7e7a..f7744f1 100644 --- a/sql/base/base.sql +++ b/sql/base/base.sql @@ -2454,7 +2454,9 @@ CREATE OR REPLACE FUNCTION migration_tools.assert (BOOLEAN) RETURNS VOID AS $$ DECLARE test ALIAS FOR $1; BEGIN - ASSERT test; + IF NOT test THEN + RAISE EXCEPTION 'assertion'; + END IF; END; $$ LANGUAGE PLPGSQL STRICT VOLATILE; @@ -2463,7 +2465,9 @@ CREATE OR REPLACE FUNCTION migration_tools.assert (BOOLEAN,TEXT) RETURNS VOID AS test ALIAS FOR $1; msg ALIAS FOR $2; BEGIN - ASSERT test, msg; + IF NOT test THEN + RAISE EXCEPTION '%', msg; + END IF; END; $$ LANGUAGE PLPGSQL STRICT VOLATILE; @@ -2473,7 +2477,9 @@ CREATE OR REPLACE FUNCTION migration_tools.assert (BOOLEAN,TEXT,TEXT) RETURNS TE fail_msg ALIAS FOR $2; success_msg ALIAS FOR $3; BEGIN - ASSERT test, fail_msg; + IF NOT test THEN + RAISE EXCEPTION '%', fail_msg; + END IF; RETURN success_msg; END; $$ LANGUAGE PLPGSQL STRICT VOLATILE;