aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDylan William Hardison <dylan@hardison.net>2014-09-28 23:24:39 -0400
committerDylan William Hardison <dylan@hardison.net>2014-09-28 23:24:39 -0400
commite6fa99287f4aaa2e2f134ca8e0eebb39c2cc2b6a (patch)
treea061cdc30f216e86714b1b8cd2a952515d649aa8
parentBug 1071024 - improve description of mail_delivery_method. r=glob. (diff)
downloadbugzilla-e6fa99287f4aaa2e2f134ca8e0eebb39c2cc2b6a.tar.gz
bugzilla-e6fa99287f4aaa2e2f134ca8e0eebb39c2cc2b6a.tar.bz2
bugzilla-e6fa99287f4aaa2e2f134ca8e0eebb39c2cc2b6a.zip
Bug 1044457 - PostgreSQL 8.x fails with error: language "plpgsql" does not exist
-rw-r--r--Bugzilla/DB/Pg.pm3
1 files changed, 3 insertions, 0 deletions
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