From 12694cb4bfbe7e4fd3cdfe40d0a7cc5f254dabf3 Mon Sep 17 00:00:00 2001
From: Darold Gilles <gilles@darold.net>
Date: Fri, 27 Apr 2012 12:30:29 +0200
Subject: [PATCH] Add more "normalization" on errors messages

---
 pgbadger | 9 ++++++++-
 1 file changed, 8 insertions(+), 1 deletion(-)

diff --git a/pgbadger b/pgbadger
index 09b0ccc..9c01c17 100755
--- a/pgbadger
+++ b/pgbadger
@@ -2001,9 +2001,16 @@ sub normalize_error
 	my $orig_query = shift;
 
 	return if (!$orig_query);
-
+	
 	# Remove character position
 	$orig_query =~ s/ at character \d+//;
+	# Remove encoding detail
+	$orig_query =~ s/(byte sequence for encoding).*/$1/;
+	# Replace changing parameter by ...
+	$orig_query =~ s/"[^"]*"/"..."/g;
+	$orig_query =~ s/\(.*\)/\(...\)/g;
+	$orig_query =~ s/column .* does not exist/column "..." does not exist/;
+	# Need more normalization stuff here
 
 	return $orig_query;
 }
-- 
2.50.1