From 82f69c72a4d3c474a089a8af6002447cec7056ef Mon Sep 17 00:00:00 2001 From: Jason Stephenson Date: Thu, 31 Jul 2014 10:29:29 -0400 Subject: [PATCH] LP#1322285: Fix the upgrade script. Add "IF EXISTS" after DROP FUNCTION, 'cause my database was missing at least one of those forms. Signed-off-by: Jason Stephenson --- Open-ILS/src/sql/Pg/upgrade/XXXX.function.no-ff-defaults.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.function.no-ff-defaults.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.function.no-ff-defaults.sql index 5060dc6e2d..970c285222 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.function.no-ff-defaults.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.function.no-ff-defaults.sql @@ -97,9 +97,9 @@ BEGIN END; $func$ LANGUAGE PLPGSQL; -DROP FUNCTION vandelay.marc21_extract_fixed_field_list( text, text ); -DROP FUNCTION vandelay.marc21_extract_fixed_field( text, text ); -DROP FUNCTION vandelay.marc21_extract_all_fixed_fields( text, text ); +DROP FUNCTION IF EXISTS vandelay.marc21_extract_fixed_field_list( text, text ); +DROP FUNCTION IF EXISTS vandelay.marc21_extract_fixed_field( text, text ); +DROP FUNCTION IF EXISTS vandelay.marc21_extract_all_fixed_fields( text, text ); COMMIT; -- 2.11.0