From f837691c132802faaf3306e8ea4c93b5f052c033 Mon Sep 17 00:00:00 2001 From: Justin Hopkins Date: Mon, 9 Jul 2012 13:18:52 -0500 Subject: [PATCH] move disabling of trigger when using mfr switch to top of script Signed-off-by: Justin Hopkins --- .gitignore | 1 - Open-ILS/src/extras/import/parallel_pg_loader.pl.in | 5 ++++- 2 files changed, 4 insertions(+), 2 deletions(-) diff --git a/.gitignore b/.gitignore index d9e24bf06f..20325e439e 100644 --- a/.gitignore +++ b/.gitignore @@ -40,7 +40,6 @@ Open-ILS/src/extras/fast-extract Open-ILS/src/extras/import/marc2are.pl Open-ILS/src/extras/import/marc2bre.pl Open-ILS/src/extras/import/marc2sre.pl -Open-ILS/src/extras/import/parallel_pg_loader.pl Open-ILS/src/extras/.libs/ Open-ILS/src/extras/Makefile Open-ILS/src/extras/Makefile.in diff --git a/Open-ILS/src/extras/import/parallel_pg_loader.pl.in b/Open-ILS/src/extras/import/parallel_pg_loader.pl.in index f276f0b8d9..5f1745008a 100755 --- a/Open-ILS/src/extras/import/parallel_pg_loader.pl.in +++ b/Open-ILS/src/extras/import/parallel_pg_loader.pl.in @@ -42,6 +42,10 @@ binmode($main_out,'utf8'); $main_out->print("SET CLIENT_ENCODING TO 'UNICODE';\n\n"); $main_out->print("BEGIN;\n\n"); +if (grep /^mfr$/, %out_files) { + $main_out->print("SELECT reporter.disable_materialized_simple_record_trigger();\n"); +} + my %out_files; for my $h (@order) { $out_files{$h} = FileHandle->new(">$output.$h.sql"); @@ -127,7 +131,6 @@ for my $hint (@order) { if (grep /^mfr$/, %out_files) { $main_out->print("SELECT reporter.enable_materialized_simple_record_trigger();\n"); - $main_out->print("SELECT reporter.disable_materialized_simple_record_trigger();\n"); } $main_out->print("COMMIT;\n\n") unless $nocommit; -- 2.11.0