From 08471ef33a9f171fca5ead3082b4be4c6353f1a7 Mon Sep 17 00:00:00 2001
From: "mkanat%bugzilla.org" <>
Date: Mon, 20 Nov 2006 12:29:55 +0000
Subject: [PATCH] Bug 361175: [PostgreSQL] Too many "NOTICE" messages from
 checksetup.pl Patch By Max Kanat-Alexander <mkanat@bugzilla.org> r=bkor,
 a=justdave

---
 Bugzilla/DB/Pg.pm | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

diff --git a/Bugzilla/DB/Pg.pm b/Bugzilla/DB/Pg.pm
index a8f54f9036..34fe66a025 100644
--- a/Bugzilla/DB/Pg.pm
+++ b/Bugzilla/DB/Pg.pm
@@ -66,7 +66,11 @@ sub new {
     # construct the DSN from the parameters we got
     my $dsn = "DBI:Pg:host=$host;dbname=$dbname";
     $dsn .= ";port=$port" if $port;
-   
+
+    # This stops Pg from printing out lots of "NOTICE" messages when
+    # creating tables.
+    $dsn .= ";options='-c client_min_messages=warning'";
+
     my $self = $class->db_new($dsn, $user, $pass);
 
     # all class local variables stored in DBI derived class needs to have
-- 
2.47.2