From 9618127a90cece79503da4c93e8ed397e8a88a16 Mon Sep 17 00:00:00 2001 From: miker Date: Sat, 26 Jul 2008 00:39:28 +0000 Subject: [PATCH 1/1] adding set_curcfg() call to tsearch2 configuration script for 8.2 and 8.1; fixing datatype of extend_reporter.legacy_circ_count.id (harmless, but useless, thinko) git-svn-id: svn://svn.open-ils.org/ILS/trunk@10141 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/000.english.pg81.fts-config.sql | 2 ++ Open-ILS/src/sql/Pg/000.english.pg82.fts-config.sql | 2 ++ Open-ILS/src/sql/Pg/extend-reporter.sql | 2 +- 3 files changed, 5 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/000.english.pg81.fts-config.sql b/Open-ILS/src/sql/Pg/000.english.pg81.fts-config.sql index d42ff973fc..1ea4ac9356 100644 --- a/Open-ILS/src/sql/Pg/000.english.pg81.fts-config.sql +++ b/Open-ILS/src/sql/Pg/000.english.pg81.fts-config.sql @@ -133,4 +133,6 @@ INSERT INTO pg_ts_cfgmap VALUES ('series', 'lword', '{en_stem_nostop}'); INSERT INTO pg_ts_cfgmap VALUES ('series', 'lpart_hword', '{en_stem_nostop}'); INSERT INTO pg_ts_cfgmap VALUES ('series', 'lhword', '{en_stem_nostop}'); +SELECT set_curcfg('default'); + COMMIT; diff --git a/Open-ILS/src/sql/Pg/000.english.pg82.fts-config.sql b/Open-ILS/src/sql/Pg/000.english.pg82.fts-config.sql index d42ff973fc..1ea4ac9356 100644 --- a/Open-ILS/src/sql/Pg/000.english.pg82.fts-config.sql +++ b/Open-ILS/src/sql/Pg/000.english.pg82.fts-config.sql @@ -133,4 +133,6 @@ INSERT INTO pg_ts_cfgmap VALUES ('series', 'lword', '{en_stem_nostop}'); INSERT INTO pg_ts_cfgmap VALUES ('series', 'lpart_hword', '{en_stem_nostop}'); INSERT INTO pg_ts_cfgmap VALUES ('series', 'lhword', '{en_stem_nostop}'); +SELECT set_curcfg('default'); + COMMIT; diff --git a/Open-ILS/src/sql/Pg/extend-reporter.sql b/Open-ILS/src/sql/Pg/extend-reporter.sql index 0197cf4273..5a6c32cc42 100644 --- a/Open-ILS/src/sql/Pg/extend-reporter.sql +++ b/Open-ILS/src/sql/Pg/extend-reporter.sql @@ -21,7 +21,7 @@ BEGIN; CREATE SCHEMA extend_reporter; CREATE TABLE extend_reporter.legacy_circ_count ( - id BIGSERIAL PRIMARY KEY REFERENCES asset.copy (id), + id BIGINT PRIMARY KEY REFERENCES asset.copy (id), circ_count INT NOT NULL DEFAULT 0 ); -- 2.43.2