From 9d1f794f6353d9487fce6c5d7ee43b35328ba30b Mon Sep 17 00:00:00 2001
From: Dobrica Pavlinusic <dpavlin@rot13.org>
Date: Thu, 17 Jan 2013 16:21:30 +0100
Subject: [PATCH] helper script to run dump and extract errors

---
 import-pgsql-dump.sh | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100755 import-pgsql-dump.sh

diff --git a/import-pgsql-dump.sh b/import-pgsql-dump.sh
new file mode 100755
index 0000000..f7b7dcf
--- /dev/null
+++ b/import-pgsql-dump.sh
@@ -0,0 +1,9 @@
+#!/bin/sh -xe
+
+touch errors
+(
+psql -l | grep ibatisti | awk '{ print $1 }' | xargs -i dropdb {}
+./pgsql-fix-value-too-long.pl errors $1 | \
+( psql --echo-queries template1 2>&1 )
+2>&1 ) | tee log
+grep -A 1 'value too long' log | tee -a errors
-- 
2.20.1