projects / evergreen / joelewis.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: a838292) | patch
do not use TRUNCATE when refreshing reporter.materialized_simple_record
authorgmc <gmc@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 10 Nov 2010 13:19:03 +0000 (13:19 +0000)
committergmc <gmc@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 10 Nov 2010 13:19:03 +0000 (13:19 +0000)
commitfd50c598df6098c81dd3c7a627cae4942372c689
treecb4baf40f245788e689db1599366369328d7751etree
parenta838292554015bf45066558d26a26e15acc4d6c5commit | 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/branches/rel_2_0@18678 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 (Joseph Lewis)