From 1fa5c0665ff6a24289f3edb32625c5ab9d53f70b Mon Sep 17 00:00:00 2001 From: gmc Date: Wed, 10 Nov 2010 13:30:39 +0000 Subject: [PATCH] do not use TRUNCATE when refreshing reporter.materialized_simple_record Previous behavior would break Slony replication after doing a bib load. Since a deletion is slower than a truncate, if you're not using Slony replication, you may prefer to truncate rmsr prior to calling reporter.enable_materialized_simple_record_trigger. Signed-off-by: Galen Charlton git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_6_1@18680 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/reporter-schema.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/reporter-schema.sql b/Open-ILS/src/sql/Pg/reporter-schema.sql index f70f4603eb..5e57d76770 100644 --- a/Open-ILS/src/sql/Pg/reporter-schema.sql +++ b/Open-ILS/src/sql/Pg/reporter-schema.sql @@ -256,7 +256,7 @@ $$ LANGUAGE plpgsql; CREATE OR REPLACE FUNCTION reporter.enable_materialized_simple_record_trigger () RETURNS VOID AS $$ - TRUNCATE TABLE reporter.materialized_simple_record; + DELETE FROM reporter.materialized_simple_record; INSERT INTO reporter.materialized_simple_record (id,fingerprint,quality,tcn_source,tcn_value,title,author,publisher,pubdate,isbn,issn) -- 2.11.0