summaryrefslogtreecommitdiffstats
path: root/Bugzilla/DB
diff options
context:
space:
mode:
authorDylan William Hardison <dylan@hardison.net>2014-09-29 05:24:39 +0200
committerDylan William Hardison <dylan@hardison.net>2014-09-29 05:24:39 +0200
commite6fa99287f4aaa2e2f134ca8e0eebb39c2cc2b6a (patch)
treea061cdc30f216e86714b1b8cd2a952515d649aa8 /Bugzilla/DB
parentf1897d398fbd9ba0c4b35d0414e2907120e39bd3 (diff)
downloadbugzilla-e6fa99287f4aaa2e2f134ca8e0eebb39c2cc2b6a.tar.gz
bugzilla-e6fa99287f4aaa2e2f134ca8e0eebb39c2cc2b6a.tar.xz
Bug 1044457 - PostgreSQL 8.x fails with error: language "plpgsql" does not exist
Diffstat (limited to 'Bugzilla/DB')
-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