From 25ff246a14279f00d6b8b0e06b757dc39108afca Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Fri, 1 Apr 2011 13:58:40 -0400 Subject: [PATCH] eliminate the last lingering errors --- Open-ILS/src/sql/Pg/999.functions.global.sql | 2 -- 1 file changed, 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/999.functions.global.sql b/Open-ILS/src/sql/Pg/999.functions.global.sql index 391949124f..82cb509afd 100644 --- a/Open-ILS/src/sql/Pg/999.functions.global.sql +++ b/Open-ILS/src/sql/Pg/999.functions.global.sql @@ -1151,8 +1151,6 @@ CREATE OR REPLACE FUNCTION asset.refresh_opac_visible_copies_mat_view () RETURNS JOIN asset.copy_location cl ON (cp.location = cl.id) JOIN config.copy_status cs ON (cp.status = cs.id) WHERE NOT cp.deleted - AND NOT cn.deleted - AND NOT b.deleted AND cs.opac_visible AND cl.opac_visible AND cp.opac_visible -- 2.11.0