projects / evergreen / masslnc.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: a48eeab) | patch
do not use TRUNCATE when refreshing reporter.materialized_simple_record
authorgmc <gmc@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 10 Nov 2010 13:18:29 +0000 (13:18 +0000)
committergmc <gmc@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 10 Nov 2010 13:18:29 +0000 (13:18 +0000)
commit85efd3b40bc3d53d7d004b8bd02a89bd7ceeaa1f
treebbfae9d842a7b89b4e5b5830843346971c943c5etree
parenta48eeabd98c1f9e9def057d5b0b27e2bbe1771f8commit | diff
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 <gmc@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@18677 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/sql/Pg/002.schema.config.sql diff | blob | history
Open-ILS/src/sql/Pg/reporter-schema.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/0462.schema.no-truncate-during-bib-view-refresh.sql [new file with mode: 0644] blob
Evergreen working repo (MassLNC)