From 74465efe0a7892afc76366917e34e3fe2d6fce33 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Fri, 6 Dec 2013 11:20:36 -0500 Subject: [PATCH] Dropping a staged search function preventing the 2.3-2.4.0 script from completing. --- Open-ILS/src/sql/Pg/version-upgrade/pines-2.3-2.4.0-upgrade-db.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/pines-2.3-2.4.0-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/pines-2.3-2.4.0-upgrade-db.sql index a87b32eade..6dd0bfce82 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/pines-2.3-2.4.0-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/pines-2.3-2.4.0-upgrade-db.sql @@ -89,6 +89,8 @@ DROP INDEX metabib.metabib_series_field_entry_index_vector_idx; DROP INDEX metabib.metabib_subject_field_entry_index_vector_idx; DROP INDEX metabib.metabib_title_field_entry_index_vector_idx; +-- And dropping a function used by PINES +DROP FUNCTION search.staged_fts(integer,integer,text,integer[],integer[],text[],text[],text[],text[],text[],text[],text,real,text,boolean,boolean,boolean,integer,integer,integer); -- Now grab all of the tsvector-enabled columns and switch them to the non-wrapper version of the type. ALTER TABLE authority.full_rec ALTER COLUMN index_vector TYPE pg_catalog.tsvector; -- 2.11.0