From ef67310918e9f98716eec86f2eb05eb728b9d845 Mon Sep 17 00:00:00 2001
From: miker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Date: Fri, 13 Mar 2009 02:32:07 +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/branches/rel_1_4_0@12507 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 b6117741e5..4c82dadf90 100755
--- a/Open-ILS/src/extras/import/parallel_pg_loader.pl
+++ b/Open-ILS/src/extras/import/parallel_pg_loader.pl
@@ -121,8 +121,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");
 $main_out->close; 
+
-- 
2.11.0