From b417d5a57dc26b3180af17097349a3224a5e50cb Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Wed, 1 May 2013 15:01:30 -0400 Subject: [PATCH] LP#1174359: follow-up on dropping the reporter.classic_item_list view Add note for the benefit of any Evergreen admin who may need to recreate that view. Also, update the point schema update script. Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/upgrade/0743.schema.remove_tsearch2.sql | 5 +++++ .../src/sql/Pg/version-upgrade/2.3-2.4.0RC-upgrade-db.sql | 4 ++++ 2 files changed, 9 insertions(+) diff --git a/Open-ILS/src/sql/Pg/upgrade/0743.schema.remove_tsearch2.sql b/Open-ILS/src/sql/Pg/upgrade/0743.schema.remove_tsearch2.sql index 062e5a2c6b..eab7d7d45d 100644 --- a/Open-ILS/src/sql/Pg/upgrade/0743.schema.remove_tsearch2.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0743.schema.remove_tsearch2.sql @@ -15,6 +15,11 @@ DROP FUNCTION IF EXISTS biblio.flatten_marc(text); -- These views depend on metabib.full_rec as well. Bye-bye! DROP VIEW IF EXISTS reporter.old_super_simple_record; DROP VIEW IF EXISTS reporter.simple_record; +DROP VIEW IF EXISTS reporter.classic_item_list; + +\echo WARNING: The reporter.classic_item_list view was dropped if it existed. +\echo If you use that view, please run the example.reporter-extension.sql script +\echo to recreate it after rest of the schema upgrade is complete. -- Now we can drop metabib.full_rec. DROP VIEW IF EXISTS metabib.full_rec; diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.3-2.4.0RC-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.3-2.4.0RC-upgrade-db.sql index 8c122c4432..8d957dbda3 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/2.3-2.4.0RC-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/2.3-2.4.0RC-upgrade-db.sql @@ -64,6 +64,10 @@ DROP VIEW IF EXISTS reporter.old_super_simple_record; DROP VIEW IF EXISTS reporter.simple_record; DROP VIEW IF EXISTS reporter.classic_item_list; +\echo WARNING: The reporter.classic_item_list view was dropped if it existed. +\echo If you use that view, please run the example.reporter-extension.sql script +\echo to recreate it after rest of the schema upgrade is complete. + -- Now we can drop metabib.full_rec. DROP VIEW IF EXISTS metabib.full_rec; -- 2.43.2