From eaca9cd603da425a82ad478c7798645ea45c2178 Mon Sep 17 00:00:00 2001
From: Bill Erickson <berickxx@gmail.com>
Date: Mon, 7 Jan 2019 10:49:28 -0500
Subject: [PATCH] LP1810802 org_top() SQL upgrade repairs
1. Drop the org_top function before recreating it since the return type
changes.
2. Fis syntax error in "COMMIT:"
Signed-off-by: Bill Erickson <berickxx@gmail.com>
Signed-off-by: Jason Stephenson <jason@sigio.com>
---
.../Pg/upgrade/1140.function.non-set-returning-evergreen.org_top.sql | 4 +++-
1 file changed, 3 insertions(+), 1 deletion(-)
diff --git a/Open-ILS/src/sql/Pg/upgrade/1140.function.non-set-returning-evergreen.org_top.sql b/Open-ILS/src/sql/Pg/upgrade/1140.function.non-set-returning-evergreen.org_top.sql
index c7ff6476c0..105136c056 100644
--- a/Open-ILS/src/sql/Pg/upgrade/1140.function.non-set-returning-evergreen.org_top.sql
+++ b/Open-ILS/src/sql/Pg/upgrade/1140.function.non-set-returning-evergreen.org_top.sql
@@ -2,9 +2,11 @@ BEGIN;
SELECT evergreen.upgrade_deps_block_check('1140', :eg_version);
+DROP FUNCTION IF EXISTS evergreen.org_top();
+
CREATE OR REPLACE FUNCTION evergreen.org_top()
RETURNS actor.org_unit AS $$
SELECT * FROM actor.org_unit WHERE parent_ou IS NULL LIMIT 1;
$$ LANGUAGE SQL STABLE;
-COMMIT:
+COMMIT;
--
2.11.0