From 9f5723e9ebdb55e14ff89b26b2250d96e64ffb3d Mon Sep 17 00:00:00 2001 From: Ben Ostrowsky Date: Thu, 5 Jan 2012 14:11:06 +0000 Subject: [PATCH] Avoid collisions while refreshing OPAC visibility --- sql/base/base.sql | 5 +++-- 1 files changed, 3 insertions(+), 2 deletions(-) diff --git a/sql/base/base.sql b/sql/base/base.sql index cb9dab4..0ebfb54 100644 --- a/sql/base/base.sql +++ b/sql/base/base.sql @@ -1275,7 +1275,7 @@ BEGIN DELETE FROM asset.opac_visible_copies; INSERT INTO asset.opac_visible_copies (id, circ_lib, record) - SELECT + SELECT DISTINCT cp.id, cp.circ_lib, cn.record FROM asset.copy cp @@ -1291,7 +1291,8 @@ BEGIN cs.opac_visible AND cl.opac_visible AND cp.opac_visible AND - a.opac_visible; + a.opac_visible AND + cp.id NOT IN (SELECT id FROM asset.opac_visible_copies); END; -- 1.7.2.5