1 -- Rather than polluting the public schema with general Evergreen
2 -- functions, carve out a dedicated schema
4 DROP SCHEMA IF EXISTS evergreen CASCADE;
8 CREATE SCHEMA evergreen;
10 CREATE OR REPLACE FUNCTION evergreen.lowercase( TEXT ) RETURNS TEXT AS $$
12 $$ LANGUAGE PLPERLU STRICT IMMUTABLE;
14 CREATE OR REPLACE FUNCTION evergreen.xml_escape(str TEXT) RETURNS text AS $$
15 SELECT REPLACE(REPLACE(REPLACE($1,
19 $$ LANGUAGE SQL IMMUTABLE;
21 CREATE OR REPLACE FUNCTION evergreen.change_db_setting(setting_name TEXT, settings TEXT[]) RETURNS VOID AS $$
23 EXECUTE 'ALTER DATABASE ' || quote_ident(current_database()) || ' SET ' || quote_ident(setting_name) || ' = ' || array_to_string(settings, ',');
27 SELECT evergreen.change_db_setting('search_path', ARRAY['public','pg_catalog']);