From 95f27782ac3d222ed9320b3e47b3c985d9cfedd9 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/2.0-2.1-upgrade-db.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql b/Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql index 25e4d12f43..81fdcc8f70 100644 --- a/Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/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