From 5b69128dc054e4b8b79606f76fe614aca211151a Mon Sep 17 00:00:00 2001 From: Lebbeous Fogle-Weekley Date: Mon, 19 Mar 2012 11:17:38 -0400 Subject: [PATCH] TPAC: ROWS 1 not appropriate here. I must have thrown this in as a misguided afterthought without testing it. Signed-off-by: Lebbeous Fogle-Weekley Signed-off-by: Dan Wells Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/020.schema.functions.sql | 2 +- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.serial-holding-groups.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/020.schema.functions.sql b/Open-ILS/src/sql/Pg/020.schema.functions.sql index de70132ead..81dcdfca75 100644 --- a/Open-ILS/src/sql/Pg/020.schema.functions.sql +++ b/Open-ILS/src/sql/Pg/020.schema.functions.sql @@ -248,7 +248,7 @@ RETURNS INT[] AS $$ FROM actor.org_unit aou JOIN descendant_depth dd USING (id) WHERE aou.id = $1 ORDER BY dd.path; -$$ LANGUAGE SQL STABLE ROWS 1; +$$ LANGUAGE SQL STABLE; CREATE OR REPLACE FUNCTION actor.org_unit_proximity ( INT, INT ) RETURNS INT AS $$ SELECT COUNT(id)::INT FROM ( diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.serial-holding-groups.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.serial-holding-groups.sql index f27fc79078..d395430f8e 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.serial-holding-groups.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.serial-holding-groups.sql @@ -65,7 +65,7 @@ RETURNS INT[] AS $$ FROM actor.org_unit aou JOIN descendant_depth dd USING (id) WHERE aou.id = $1 ORDER BY dd.path; -$$ LANGUAGE SQL STABLE ROWS 1; +$$ LANGUAGE SQL STABLE; CREATE TABLE serial.materialized_holding_code ( id BIGSERIAL PRIMARY KEY, -- 2.11.0