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

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

Revision: 667
          http://postfixadmin.svn.sourceforge.net/postfixadmin/?rev=667&view=rev
Author:   GingerDog
Date:     2009-05-28 19:47:52 +0000 (Thu, 28 May 2009)

Log Message:
-----------
try and avoid naming conflicts so put _idx on the end of all postgres indexes

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

Modified: trunk/upgrade.php
===================================================================
--- trunk/upgrade.php	2009-05-24 11:12:34 UTC (rev 666)
+++ trunk/upgrade.php	2009-05-28 19:47:52 UTC (rev 667)
@@ -229,7 +229,7 @@
     if ($CONF['database_type'] == 'mysql' || $CONF['database_type'] == 'mysqli' ) {
         return "ALTER TABLE $table ADD INDEX `$indexname` ( `$fieldlist` )";
     } elseif($CONF['database_type'] == 'pgsql') {
-        $pgindexname = $table . "_" . $indexname;
+        $pgindexname = $table . "_" . $indexname . '_idx';
         return "CREATE INDEX $pgindexname ON $table($fieldlist);"; # Index names are unique with a DB for PostgreSQL
     } else {
         echo "Sorry, unsupported database type " . $conf['database_type'];


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