From 73e5931b51a0b51afd9690d7cbb5e723b47856b0 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Fri, 2 Jun 2017 10:36:59 -0400 Subject: [PATCH] JBAS-1554 Aged circ SQL update drop repair DROP some functions before a view they depend on is replaced. Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/aged-circs-api.sql | 3 +++ 1 file changed, 3 insertions(+) diff --git a/KCLS/sql/schema/deploy/aged-circs-api.sql b/KCLS/sql/schema/deploy/aged-circs-api.sql index 2e869ab480..dbe7b17855 100644 --- a/KCLS/sql/schema/deploy/aged-circs-api.sql +++ b/KCLS/sql/schema/deploy/aged-circs-api.sql @@ -7,7 +7,10 @@ BEGIN; \set eg_version '''2.7.8''' SELECT evergreen.upgrade_deps_block_check('0998', :eg_version); +DROP FUNCTION action.summarize_all_circ_chain (INTEGER); +DROP FUNCTION action.all_circ_chain (INTEGER); DROP VIEW IF EXISTS action.all_circulation; + CREATE VIEW action.all_circulation AS SELECT aged_circulation.id, aged_circulation.usr_post_code, aged_circulation.usr_home_ou, aged_circulation.usr_profile, -- 2.11.0