From 45eaac540bd7152478b18852706a621ba374ed33 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Wed, 21 Jun 2017 12:57:07 -0700 Subject: [PATCH] JBAS-1554 Aged circ SQL update drop repair cont. Avoid trying to drop functions that may not yet exist. Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/aged-circs-api.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/KCLS/sql/schema/deploy/aged-circs-api.sql b/KCLS/sql/schema/deploy/aged-circs-api.sql index dbe7b17855..19a5908187 100644 --- a/KCLS/sql/schema/deploy/aged-circs-api.sql +++ b/KCLS/sql/schema/deploy/aged-circs-api.sql @@ -7,8 +7,8 @@ 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 FUNCTION IF EXISTS action.summarize_all_circ_chain (INTEGER); +DROP FUNCTION IF EXISTS action.all_circ_chain (INTEGER); DROP VIEW IF EXISTS action.all_circulation; CREATE VIEW action.all_circulation AS -- 2.11.0