From 5aea1c5c5f8ce39d98ecdf407dd33b25bb927f11 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Wed, 15 Jan 2014 16:47:47 -0500 Subject: [PATCH] Always replace sorter values Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/030.schema.metabib.sql | 8 ++------ 1 file changed, 2 insertions(+), 6 deletions(-) diff --git a/Open-ILS/src/sql/Pg/030.schema.metabib.sql b/Open-ILS/src/sql/Pg/030.schema.metabib.sql index 9cdcf716c0..e7e5f832f0 100644 --- a/Open-ILS/src/sql/Pg/030.schema.metabib.sql +++ b/Open-ILS/src/sql/Pg/030.schema.metabib.sql @@ -1474,12 +1474,8 @@ BEGIN END IF; IF attr_def.sorter THEN - IF rdeleted THEN -- initial insert OR revivication - DELETE FROM metabib.record_sorter WHERE source = rid AND attr = attr_def.name; - INSERT INTO metabib.record_sorter (source, attr, value) VALUES (rid, attr_def.name, norm_attr_value[1]); - ELSE - UPDATE metabib.record_sorter SET value = norm_attr_value[1] WHERE source = rid AND attr = attr_def.name; - END IF; + DELETE FROM metabib.record_sorter WHERE source = rid AND attr = attr_def.name; + INSERT INTO metabib.record_sorter (source, attr, value) VALUES (rid, attr_def.name, norm_attr_value[1]); END IF; END LOOP; -- 2.11.0