From 8a7b3c61b459b5443aac9489b9ebddac259e153b Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Mon, 6 Aug 2012 11:42:22 -0400 Subject: [PATCH] add another table to the configuration export Signed-off-by: Galen Charlton --- sql/base/base.sql | 3 +++ 1 files changed, 3 insertions(+), 0 deletions(-) diff --git a/sql/base/base.sql b/sql/base/base.sql index 6ca7af1..54f0a9d 100644 --- a/sql/base/base.sql +++ b/sql/base/base.sql @@ -1660,6 +1660,9 @@ BEGIN EXECUTE $$COPY (SELECT name, owning_lib, holdable, hold_verify, opac_visible, circulate FROM asset.copy_location WHERE owning_lib IN ($$ || ARRAY_TO_STRING(orgs, ',') || $$)$$ || $$) TO '$$ || dir || $$/asset_copy_location'$$; + EXECUTE $$COPY (SELECT grp, org_unit, penalty, threshold FROM permission.grp_penalty_threshold WHERE org_unit IN ($$ || + ARRAY_TO_STRING(orgs, ',') || $$)$$ || + $$) TO '$$ || dir || $$/permission_grp_penalty_threshold'$$; END; $FUNC$ LANGUAGE PLPGSQL; -- 1.7.2.5