From f50aa3ea85f7832d806dc5043b30098bc30f4aff Mon Sep 17 00:00:00 2001 From: miker Date: Fri, 13 Mar 2009 02:19:45 +0000 Subject: [PATCH] teach parallel_pg_loader.pl to set the sequence on non-auto tables after loading data into them git-svn-id: svn://svn.open-ils.org/ILS/trunk@12505 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/extras/import/parallel_pg_loader.pl | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/Open-ILS/src/extras/import/parallel_pg_loader.pl b/Open-ILS/src/extras/import/parallel_pg_loader.pl index 1cabb7aef3..fa49ac3192 100755 --- a/Open-ILS/src/extras/import/parallel_pg_loader.pl +++ b/Open-ILS/src/extras/import/parallel_pg_loader.pl @@ -123,8 +123,16 @@ while ( my $rec = <> ) { $count++; } +for my $hint (@order) { + next if (grep { $_ eq $hint} @auto); + next unless ($fieldcache{$hint}{sequence}); + $main_out->print("SELECT setval('$fieldcache{$hint}{sequence}'::TEXT, (SELECT MAX($fieldcache{$hint}{pkey}) FROM $fieldcache{$hint}{table}), TRUE);\n\n"); +} + if (grep /^mfr$/, %out_files) { $main_out->print("SELECT reporter.enable_materialized_simple_record_trigger();\n"); } + $main_out->print("COMMIT;\n\n") unless $nocommit; $main_out->close; + -- 2.11.0