SF.net SVN: postfixadmin:[738] trunk/upgrade.php

[<Gin...@us...>]

Revision: 738
          http://postfixadmin.svn.sourceforge.net/postfixadmin/?rev=738&view=rev
Author:   GingerDog
Date:     2009-10-24 19:44:32 +0000 (Sat, 24 Oct 2009)

Log Message:
-----------
create the plpgsql language if it is not already there; will error if already enabled, but we will just ignore this - this may cause issues if the db user does not have priviledges to create language ... if this is the case the next query will fail

Modified Paths:
--------------
    trunk/upgrade.php

Modified: trunk/upgrade.php
===================================================================
--- trunk/upgrade.php	2009-10-24 00:13:39 UTC (rev 737)
+++ trunk/upgrade.php	2009-10-24 19:44:32 UTC (rev 738)
@@ -1118,6 +1118,7 @@
     $table_quota = table_by_key('quota');
     $table_quota2 = table_by_key('quota2');
 
+    db_query_parsed('CREATE LANGUAGE plpgsql', 1); /* will error if plpgsql is already installed */
     # trigger for dovecot v1.0 & 1.1 quota table
     # taken from http://wiki.dovecot.org/Quota/Dict
     db_query_parsed("


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.