From a1c2d33e85b5da41b4f15df71ce287118c844e2b Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 27 Sep 2018 10:37:24 -0400 Subject: [PATCH] JBAS-1832 3.2 upgrade SQL reorder; more logging Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/3.2-data-billing-timestamps.sql | 3 +++ KCLS/sql/schema/deploy/3.2-data-name-keywords.sql | 3 +++ 2 files changed, 6 insertions(+) diff --git a/KCLS/sql/schema/deploy/3.2-data-billing-timestamps.sql b/KCLS/sql/schema/deploy/3.2-data-billing-timestamps.sql index 268c56f361..1621f5b4ba 100644 --- a/KCLS/sql/schema/deploy/3.2-data-billing-timestamps.sql +++ b/KCLS/sql/schema/deploy/3.2-data-billing-timestamps.sql @@ -70,6 +70,9 @@ END; $$ LANGUAGE PLPGSQL; CREATE TRIGGER maintain_billing_ts_tgr BEFORE INSERT OR UPDATE ON money.billing FOR EACH ROW EXECUTE PROCEDURE money.maintain_billing_ts(); + +SELECT CLOCK_TIMESTAMP(), 'Done updating billings'; + COMMIT; diff --git a/KCLS/sql/schema/deploy/3.2-data-name-keywords.sql b/KCLS/sql/schema/deploy/3.2-data-name-keywords.sql index d214decc65..9ee8a8867a 100644 --- a/KCLS/sql/schema/deploy/3.2-data-name-keywords.sql +++ b/KCLS/sql/schema/deploy/3.2-data-name-keywords.sql @@ -20,5 +20,8 @@ UPDATE actor.usr SET name_kw_tsvector = COALESCE(suffix, '') ); + +SELECT CLOCK_TIMESTAMP(), 'Done updating name keywords vector'; + COMMIT; -- 2.11.0