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.change_db_setting(setting_name TEXT, settings TEXT[]) RETURNS VOID AS $$
16 EXECUTE 'ALTER DATABASE ' || quote_ident(current_database()) || ' SET ' || quote_ident(setting_name) || ' = ' || array_to_string(settings, ',');
20 SELECT evergreen.change_db_setting('search_path', ARRAY['public','pg_catalog']);