From a270c57708ad21f888efa42993400d01e994edc7 Mon Sep 17 00:00:00 2001 From: Dan Scott Date: Thu, 29 Dec 2011 13:46:24 -0500 Subject: [PATCH] SETVAL the permission.grp_tree sequence after adding pinned IDs If we do not update the associated sequence after adding pinned IDs, sites will be unable to add new permission groups until enough attempts have failed. Let's bypass that little bit of pain. Signed-off-by: Dan Scott --- Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql index 9e34a9d2d2..36b5700fa4 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql @@ -5797,7 +5797,7 @@ INSERT INTO permission.grp_tree (id, name, parent, description, perm_interval, u id = 15 ); - +SELECT SETVAL('permission.grp_tree_id_seq'::TEXT, (SELECT MAX(id) FROM permission.grp_tree)); INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) SELECT -- 2.11.0