From 7f1ae7e5d686e9f4d6ee62b9d22aa88ac3eb116d Mon Sep 17 00:00:00 2001 From: Dan Scott Date: Wed, 26 Jun 2013 23:01:36 -0400 Subject: [PATCH] Sign off on apostrophe upgrade script Also had to quote the \qecho commands to prevent them from being executed instead of simply set to STDOUT. Signed-off-by: Dan Scott Conflicts: Open-ILS/src/sql/Pg/002.schema.config.sql --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...trophe-search.sql => 0800.function.apostrophe-search.sql} | 12 ++++++------ 2 files changed, 7 insertions(+), 7 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.function.apostrophe-search.sql => 0800.function.apostrophe-search.sql} (96%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 7180d015cc..00daaee279 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -91,7 +91,7 @@ CREATE TRIGGER no_overlapping_deps BEFORE INSERT OR UPDATE ON config.db_patch_dependencies FOR EACH ROW EXECUTE PROCEDURE evergreen.array_overlap_check ('deprecates'); -INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0799', :eg_version); -- mrpeters/paxed/bshum +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0800', :eg_version); -- miker/dbs CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.function.apostrophe-search.sql b/Open-ILS/src/sql/Pg/upgrade/0800.function.apostrophe-search.sql similarity index 96% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.function.apostrophe-search.sql rename to Open-ILS/src/sql/Pg/upgrade/0800.function.apostrophe-search.sql index 3b7e26f904..b5c2fc2ba6 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.function.apostrophe-search.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0800.function.apostrophe-search.sql @@ -1,6 +1,6 @@ BEGIN; -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('0800', :eg_version); CREATE OR REPLACE FUNCTION metabib.reingest_metabib_field_entries( bib_id BIGINT, skip_facet BOOL DEFAULT FALSE, skip_browse BOOL DEFAULT FALSE, skip_search BOOL DEFAULT FALSE ) RETURNS VOID AS $func$ DECLARE @@ -193,10 +193,10 @@ COMMIT; \qecho **** your entire bibliographic data set, consider generating an SQL script \qecho **** with the following query, and running that via psql: \qecho -\qecho \t -\qecho \o /tmp/reingest-2.4.1.sql -\qecho SELECT 'select metabib.reingest_metabib_field_entries(' || id || ');' FROM biblio.record_entry WHERE NOT DELETED AND id > 0; -\qecho \o -\qecho \t +\qecho '\\t' +\qecho '\\o /tmp/reingest-2.4.1.sql' +\qecho 'SELECT ''select metabib.reingest_metabib_field_entries('' || id || '');'' FROM biblio.record_entry WHERE NOT DELETED AND id > 0;' +\qecho '\\o' +\qecho '\\t' \qecho -- 2.11.0