From 6e1602827c12879febdcf4e20714ca4e184f8352 Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Tue, 11 Apr 2017 16:04:25 -0400 Subject: [PATCH] ASSERT not supported until PG 9.5 Signed-off-by: Jason Etheridge --- sql/base/base.sql | 12 +++++++++--- 1 files changed, 9 insertions(+), 3 deletions(-) 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; -- 1.7.2.5