From 15b32aa736de07ac4393e67647adabae3b5649ac Mon Sep 17 00:00:00 2001
From: "mkanat%kerio.com" <>
Date: Thu, 18 Aug 2005 01:23:21 +0000
Subject: [PATCH] Bug 296054: [PostgreSQL] Cannot add a new query for
 event/whining Patch By Max Kanat-Alexander <mkanat@bugzilla.org> r=LpSolit,
 a=justdave

---
 Bugzilla/DB/Schema.pm | 3 ++-
 checksetup.pl         | 6 ++++++
 2 files changed, 8 insertions(+), 1 deletion(-)

diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm
index f86f47965c..3e86cc50d0 100644
--- a/Bugzilla/DB/Schema.pm
+++ b/Bugzilla/DB/Schema.pm
@@ -915,7 +915,8 @@ use constant ABSTRACT_SCHEMA => {
                               DEFAULT => '0'},
             onemailperbug => {TYPE => 'BOOLEAN', NOTNULL => 1,
                               DEFAULT => 'FALSE'},
-            title         => {TYPE => 'varchar(128)', NOTNULL => 1},
+            title         => {TYPE => 'varchar(128)', NOTNULL => 1,
+                              DEFAULT => "''"},
         ],
         INDEXES => [
             whine_queries_eventid_idx => ['eventid'],
diff --git a/checksetup.pl b/checksetup.pl
index 9c7a63767a..2075a4da04 100755
--- a/checksetup.pl
+++ b/checksetup.pl
@@ -3988,6 +3988,12 @@ if (Param('defaultopsys') eq 'other') {
         . "         uses 'Other' (capital O).\n";
 }
 
+# Add a DEFAULT to whine_queries stuff so that editwhines.cgi
+# works on PostgreSQL.
+$dbh->bz_alter_column('whine_queries', 'title', {TYPE => 'varchar(128)', 
+                      NOTNULL => 1, DEFAULT => "''"});
+
+
 # If you had to change the --TABLE-- definition in any way, then add your
 # differential change code *** A B O V E *** this comment.
 #
-- 
2.47.2