From: Rogan Hamby <rhamby@esilibrary.com>
Date: Thu, 14 Jun 2018 12:56:34 +0000 (-0400)
Subject: needed to add explicity schema to function call from another function
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=c345f1df91b1351d903c3cdcc046f7d7f64d8f87

needed to add explicity schema to function call from another function
---

diff --git a/sql/base/base.sql b/sql/base/base.sql
index 7c395ff..e7096d4 100644
--- a/sql/base/base.sql
+++ b/sql/base/base.sql
@@ -3539,7 +3539,7 @@ BEGIN
 
     EXECUTE 'SELECT marc FROM ' || bib_table || ' WHERE id = ' || bib_id INTO source_xml;
 
-    SELECT add_sf9(source_xml, target_u_text, sf9_text) INTO new_xml;
+    SELECT migration_tools.add_sf9(source_xml, target_u_text, sf9_text) INTO new_xml;
 
     r = FALSE;
 	new_xml = '$_$' || new_xml || '$_$';