From c782dfa2ecb714484117c7365f13919aada03c61 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Mon, 17 Apr 2017 08:23:19 -0700 Subject: [PATCH] JBAS-1554 Aged circ index timeout Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/aged-circs-api.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/KCLS/sql/schema/deploy/aged-circs-api.sql b/KCLS/sql/schema/deploy/aged-circs-api.sql index 5fc7853789..e118d6fc91 100644 --- a/KCLS/sql/schema/deploy/aged-circs-api.sql +++ b/KCLS/sql/schema/deploy/aged-circs-api.sql @@ -1,6 +1,7 @@ -- Deploy kcls-evergreen:aged-circs-api to pg -- requires: patron-co-history-table + BEGIN; \set eg_version '''2.7.8''' @@ -143,6 +144,7 @@ $$ LANGUAGE 'plpgsql'; COMMIT; -- create index on parent_circ after main transaction. +SET STATEMENT_TIMEOUT = 0; CREATE INDEX action_aged_circulation_parent_circ_idx ON action.aged_circulation (parent_circ); -- 2.11.0