From 08cd31db39000e341ae52d70127f0d25052387ca Mon Sep 17 00:00:00 2001 From: Ben Ostrowsky Date: Thu, 1 Dec 2011 12:53:11 +0000 Subject: [PATCH] Replaced TRUNCATE with DELETE FROM --- sql/base/base.sql | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/sql/base/base.sql b/sql/base/base.sql index 18d0465..297c687 100644 --- a/sql/base/base.sql +++ b/sql/base/base.sql @@ -1272,7 +1272,7 @@ CREATE OR REPLACE FUNCTION migration_tools.refresh_opac_visible_copies ( ) RETUR BEGIN - TRUNCATE asset.opac_visible_copies; + DELETE FROM asset.opac_visible_copies; INSERT INTO asset.opac_visible_copies (id, circ_lib, record) SELECT -- 1.7.2.5