Fix functions stranded in the evergreen schema without a search path reference (ugly...

[evergreen-equinox.git] / Open-ILS / src / sql / Pg / 030.schema.metabib.sql

diff --git a/Open-ILS/src/sql/Pg/030.schema.metabib.sql b/Open-ILS/src/sql/Pg/030.schema.metabib.sql
index 68ba313..8530aaf 100644 (file)
--- a/Open-ILS/src/sql/Pg/030.schema.metabib.sql
+++ b/Open-ILS/src/sql/Pg/030.schema.metabib.sql
@@ -135,7 +135,7 @@ CREATE INDEX metabib_facet_entry_field_idx ON metabib.facet_entry (field);
 CREATE INDEX metabib_facet_entry_value_idx ON metabib.facet_entry (SUBSTRING(value,1,1024));
 CREATE INDEX metabib_facet_entry_source_idx ON metabib.facet_entry (source);
 
-CREATE OR REPLACE FUNCTION facet_force_nfc() RETURNS TRIGGER AS $$
+CREATE OR REPLACE FUNCTION evergreen.facet_force_nfc() RETURNS TRIGGER AS $$
 BEGIN
     NEW.value := force_unicode_normal_form(NEW.value,'NFC');
     RETURN NEW;
@@ -144,7 +144,7 @@ $$ LANGUAGE PLPGSQL;
 
 CREATE TRIGGER facet_force_nfc_tgr
        BEFORE UPDATE OR INSERT ON metabib.facet_entry
-       FOR EACH ROW EXECUTE PROCEDURE facet_force_nfc();
+       FOR EACH ROW EXECUTE PROCEDURE evergreen.facet_force_nfc();
 
 CREATE TABLE metabib.record_attr (
        id              BIGINT  PRIMARY KEY REFERENCES biblio.record_entry (id) ON DELETE CASCADE,