From 383e99e07ee3e1e8a27deafbb31663d4fc50e231 Mon Sep 17 00:00:00 2001 From: Michael Peters Date: Mon, 29 Apr 2013 11:14:39 -0400 Subject: [PATCH] LP#1174359 Need to drop reporter.classic_item_list ERROR: cannot drop view metabib.full_rec because other objects depend on it DETAIL: view reporter.classic_item_list depends on view metabib.full_rec HINT: Use DROP ... CASCADE to drop the dependent objects too. Beginning at line 55 of the upgrade script, several views and functions are dropped so metabib.full_rec can be dropped. One of them is missing. We need to drop reporter.classic_item_list as well, for the script to work. Signed-off-by: Michael Peters Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/version-upgrade/2.3-2.4.0RC-upgrade-db.sql | 1 + 1 file changed, 1 insertion(+) 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 9e31d3bef5..8c122c4432 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 @@ -62,6 +62,7 @@ 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; -- Now we can drop metabib.full_rec. DROP VIEW IF EXISTS metabib.full_rec; -- 2.11.0