From e6fa99287f4aaa2e2f134ca8e0eebb39c2cc2b6a Mon Sep 17 00:00:00 2001
From: Dylan William Hardison <dylan@hardison.net>
Date: Sun, 28 Sep 2014 23:24:39 -0400
Subject: Bug 1044457 - PostgreSQL 8.x fails with error: language "plpgsql"
 does not exist

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

(limited to 'Bugzilla')

diff --git a/Bugzilla/DB/Pg.pm b/Bugzilla/DB/Pg.pm
index 9c5758432..4ec95725d 100644
--- a/Bugzilla/DB/Pg.pm
+++ b/Bugzilla/DB/Pg.pm
@@ -231,6 +231,9 @@ sub bz_setup_database {
     my $self = shift;
     $self->SUPER::bz_setup_database(@_);
 
+    my ($has_plpgsql) = $self->selectrow_array("SELECT COUNT(*) FROM pg_language WHERE lanname = 'plpgsql'");
+    $self->do('CREATE LANGUAGE plpgsql') unless $has_plpgsql;
+
     # Custom Functions
 
     # -Copyright © 2013 Joshua D. Burns (JDBurnZ) and Message In Action LLC
-- 
cgit v1.2.1