[Pkg-nagios-changes] [SCM] debian packaging of icinga(-core) branch, master, updated. debian/1.6.1-2-22-gc1c3991

[Alexander Wirt]

The following commit has been merged in the master branch:
commit c1c3991806d7fc890e053432e4691337260a3a32
Author: Alexander Wirt <formorer at debian.org>
Date:   Fri May 4 07:08:54 2012 +0200

    Add postgres admin functions for plperl
    
    Closes: #659675

diff --git a/debian/db/admin/pgsql b/debian/db/admin/pgsql
new file mode 100644
index 0000000..5fc5855
--- /dev/null
+++ b/debian/db/admin/pgsql
@@ -0,0 +1,18 @@
+CREATE OR REPLACE FUNCTION public.create_plpgsql_language ()
+        RETURNS TEXT
+        AS $$
+            CREATE LANGUAGE plpgsql;
+            SELECT 'language plpgsql created'::TEXT;
+        $$
+LANGUAGE 'sql';
+
+SELECT CASE WHEN
+              (SELECT true::BOOLEAN
+                 FROM pg_language
+                WHERE lanname='plpgsql')
+            THEN
+              (SELECT 'language already installed'::TEXT)
+            ELSE
+              (SELECT public.create_plpgsql_language())
+            END;
+DROP FUNCTION public.create_plpgsql_language ();

-- 
debian packaging of icinga(-core)