From 6a22c79ea3faf221a59cdfcb4930bb83e5b7e9bc Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Thu, 5 Dec 2013 11:45:04 -0500 Subject: [PATCH] Adding a pre-2.3-2.4.0 upgrade script to do some necessary datawork. --- .../sql/Pg/version-upgrade/pines-pre-2.3-2.4.0-upgrade-db.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/version-upgrade/pines-pre-2.3-2.4.0-upgrade-db.sql diff --git a/Open-ILS/src/sql/Pg/version-upgrade/pines-pre-2.3-2.4.0-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/pines-pre-2.3-2.4.0-upgrade-db.sql new file mode 100644 index 0000000000..3394d3a6c2 --- /dev/null +++ b/Open-ILS/src/sql/Pg/version-upgrade/pines-pre-2.3-2.4.0-upgrade-db.sql @@ -0,0 +1,11 @@ +-- please install Rose::URI via CPAN +BEGIN; +-- drop schemas with dependencies that get deleted +DROP SCHEMA troup CASCADE; +DROP SCHEMA tcpls CASCADE; + +-- drop a function with dependencies that get removed +DROP FUNCTION search.staged_fts(integer,integer,text,integer[],text[],text[],text[],text[],text[],text[],text,real,text,boolean,boolean,boolean,integer,integer,integer); +DROP AGGREGATE agg_tsvector(public.tsvector); +DROP FUNCTION tsvector_concat(public.tsvector,public.tsvector); +COMMIT; -- 2.11.0