From 3f1e692d14418422ff3f1bf03918d6b4087e3a76 Mon Sep 17 00:00:00 2001 From: Jason Stephenson Date: Thu, 9 May 2013 15:33:04 -0400 Subject: [PATCH] Set config.metabib_field_id_seq to 1000 in 950.data.seed-values.sql. Signed-off-by: Jason Stephenson Boosted to 1000 as suggested by Dan Scott and seconded by Bill Erickson. Signed-off-by: Dan Wells --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql index 4bdfffcd2e..2fdb6698ef 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -179,7 +179,7 @@ INSERT INTO config.metabib_field ( id, field_class, name, label, format, xpath, UPDATE config.metabib_field SET joiner = ' -- ' WHERE field_class = 'subject' AND name NOT IN ('name', 'complete'); -SELECT SETVAL('config.metabib_field_id_seq'::TEXT, (SELECT MAX(id) FROM config.metabib_field), TRUE); +SELECT SETVAL('config.metabib_field_id_seq', GREATEST(1000, (SELECT MAX(id) FROM config.metabib_field))); INSERT INTO config.metabib_search_alias (alias,field_class) VALUES ('kw','keyword'); INSERT INTO config.metabib_search_alias (alias,field_class) VALUES ('eg.keyword','keyword'); -- 2.43.2