From 83a2bef983c68cf29898a10d2d1bf114ee382090 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Tue, 30 Jan 2018 11:07:12 -0500 Subject: [PATCH] JBAS-1804 2.12 SQL wrap perm updates w/ insert check Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/2.10-to-2.12-upgrade.sql | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/KCLS/sql/schema/deploy/2.10-to-2.12-upgrade.sql b/KCLS/sql/schema/deploy/2.10-to-2.12-upgrade.sql index d2a3c7bdf3..9314e5bee2 100644 --- a/KCLS/sql/schema/deploy/2.10-to-2.12-upgrade.sql +++ b/KCLS/sql/schema/deploy/2.10-to-2.12-upgrade.sql @@ -3893,6 +3893,10 @@ $FUNK$ LANGUAGE plpgsql STABLE; SELECT 'Starting permissions updates: ', CLOCK_TIMESTAMP(); +DO $INSERT$ +BEGIN + IF evergreen.insert_on_deploy() THEN ----------------------------------- + DO $$ DECLARE fixperm TEXT[3]; DECLARE modify BOOLEAN; @@ -3952,6 +3956,10 @@ END LOOP; END$$; + END IF; +END $INSERT$; -------------------------------------------------------------- + + SELECT 'Done permissions updates: ', CLOCK_TIMESTAMP(); -- DEPS 1022 -- 2.11.0