Clean up build errors when creating/recreating database schema

[evergreen-equinox.git] / Open-ILS / src / sql / Pg / 002.functions.general.sql

diff --git a/Open-ILS/src/sql/Pg/002.functions.general.sql b/Open-ILS/src/sql/Pg/002.functions.general.sql
index 659adcc..f9407a5 100644 (file)
--- a/Open-ILS/src/sql/Pg/002.functions.general.sql
+++ b/Open-ILS/src/sql/Pg/002.functions.general.sql
@@ -1,7 +1,14 @@
 -- Rather than polluting the public schema with general Evergreen
 -- functions, carve out a dedicated schema
+
+DROP SCHEMA IF EXISTS evergreen CASCADE;
+
+BEGIN;
+
 CREATE SCHEMA evergreen;
 
 CREATE OR REPLACE FUNCTION evergreen.lowercase( TEXT ) RETURNS TEXT AS $$
     return lc(shift);
 $$ LANGUAGE PLPERLU STRICT IMMUTABLE;
+
+COMMIT;