From df84355fc597f832f69bc0f5d9eee4d04b8cc35d Mon Sep 17 00:00:00 2001
From: miker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Date: Wed, 16 Mar 2011 16:08:51 +0000
Subject: [PATCH] Update the upgrade script whith version and additional
 upgrade bits

git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_2_0@19775 dcc99617-32d9-48b4-a31d-7c20da2025e4
---
 Open-ILS/src/sql/Pg/2.0.3-2.0.4-upgrade-db.sql | 11 +++++++++++
 1 file changed, 11 insertions(+)

diff --git a/Open-ILS/src/sql/Pg/2.0.3-2.0.4-upgrade-db.sql b/Open-ILS/src/sql/Pg/2.0.3-2.0.4-upgrade-db.sql
index 8726a21757..6b9a81c751 100644
--- a/Open-ILS/src/sql/Pg/2.0.3-2.0.4-upgrade-db.sql
+++ b/Open-ILS/src/sql/Pg/2.0.3-2.0.4-upgrade-db.sql
@@ -1,5 +1,6 @@
 BEGIN;
 
+INSERT INTO config.upgrade_log (version) VALUES ('2.0.4');
 INSERT INTO config.upgrade_log (version) VALUES ('0498');
 
 -- Rather than polluting the public schema with general Evergreen
@@ -161,4 +162,14 @@ $func$ LANGUAGE PLPERLU;
 
 UPDATE asset.call_number SET id = id;
 
+INSERT INTO config.upgrade_log (version) VALUES ('0500');
+
+CREATE OR REPLACE FUNCTION evergreen.change_db_setting(setting_name TEXT, settings TEXT[]) RETURNS VOID AS $$
+BEGIN
+EXECUTE 'ALTER DATABASE ' || quote_ident(current_database()) || ' SET ' || quote_ident(setting_name) || ' = ' || array_to_string(settings, ',');
+END;
+$$ LANGUAGE plpgsql;
+
+SELECT evergreen.change_db_setting('search_path', ARRAY['public','pg_catalog']);
+
 COMMIT;
-- 
2.11.0