[Phpgroupware-cvs] CVS: setup/inc class.schema_proc_pgsql.inc.php,1.10.2.2,1.10.2.3

[Ralf Becker <address@hidden>]

Update of /cvsroot/phpgroupware/setup/inc
In directory subversions:/tmp/cvs-serv19436

Modified Files:
      Tag: Version-0_9_14-branch
        class.schema_proc_pgsql.inc.php 
Log Message:
fix for 2 pgSql bugs:
- if a table get droped (eg. uninstall an app) the sequenz got not droped, 
which leads to complains of pgSql if you tried to reinstall the table/app
- _CopyAlteredTable (which is used by AlterColumn) uses a 'SELECT * ' and then 
the $db->f(0|1|2) which leads to errors when the column-order is not as expected


Index: class.schema_proc_pgsql.inc.php
===================================================================
RCS file: 
/cvsroot/phpgroupware/setup/inc/Attic/class.schema_proc_pgsql.inc.php,v
retrieving revision 1.10.2.2
retrieving revision 1.10.2.3
diff -C2 -r1.10.2.2 -r1.10.2.3
*** class.schema_proc_pgsql.inc.php     18 Mar 2003 00:02:11 -0000      1.10.2.2
--- class.schema_proc_pgsql.inc.php     21 Mar 2003 23:48:26 -0000      1.10.2.3
***************
*** 375,379 ****
                                        }
  
!                                       if ($oProc->m_odb->f($i) != null)
                                        {
                                                switch ($arraydef['type'])
--- 375,379 ----
                                        }
  
!                                       if ($oProc->m_odb->f($name) != null)
                                        {
                                                switch ($arraydef['type'])
***************
*** 385,392 ****
                                                        case 'timestamp':
                                                        case 'varchar':
!                                                               $sSQL .= "'" . 
$oProc->m_odb->db_addslashes($oProc->m_odb->f($i)) . "'";
                                                                break;
                                                        default:
!                                                               $sSQL .= 
intval($oProc->m_odb->f($i));
                                                }
                                        }
--- 385,392 ----
                                                        case 'timestamp':
                                                        case 'varchar':
!                                                               $sSQL .= "'" . 
$oProc->m_odb->db_addslashes($oProc->m_odb->f($name)) . "'";
                                                                break;
                                                        default:
!                                                               $sSQL .= 
intval($oProc->m_odb->f($name));
                                                }
                                        }
***************
*** 398,402 ****
                                }
                                $sSQL .= ')';
- 
                                $oDB->query($sSQL);
                        }
--- 398,401 ----
***************
*** 449,453 ****
                        $this->DropSequenceForTable($oProc,$sTableName);
  
!                       return !!($oProc->m_odb->query("DROP TABLE " . 
$sTableName));
                }
  
--- 448,453 ----
                        $this->DropSequenceForTable($oProc,$sTableName);
  
!                       return $oProc->m_odb->query("DROP TABLE " . 
$sTableName) &&
!                              $this->DropSequenceForTable($oProc,$sTableName);
                }