From ab45e141f25bc085c05cd752c22d78a820756ef5 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Mon, 18 Mar 2013 18:18:21 -0400 Subject: [PATCH] explicitly add the search path for postgres and evergreen --- Open-ILS/src/sql/Pg/version-upgrade/pines-pre-2.1-2.2-upgrade.sql | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/pines-pre-2.1-2.2-upgrade.sql b/Open-ILS/src/sql/Pg/version-upgrade/pines-pre-2.1-2.2-upgrade.sql index 7d1cbb2e89..1f2639d292 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/pines-pre-2.1-2.2-upgrade.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/pines-pre-2.1-2.2-upgrade.sql @@ -1,5 +1,9 @@ -- To be run before the 2.1.1-2.1.2 upgrade script +-- explicitly set the search path for the evergreen and postgres users +ALTER ROLE postgres SET search_path TO evergreen, public ; +ALTER ROLE evergreen SET search_path TO evergreen, public ; + ---- clean up circulations that shouldn't be marked finished BEGIN; UPDATE action.circulation SET xact_finish = NULL WHERE xact_finish IS NOT NULL AND checkin_time IS NULL AND stop_fines IN ('CLAIMSRETURNED', 'MAXFINES'); -- 2.11.0