cvs: pear /MDB manager_pgsql.php

lsmith Wed Jul 10 07:17:43 2002 EDT Modified files: /pear/MDB manager_pgsql.php Log: fixed type in listViews definition sequence methods now use getSequenceName Index: pear/MDB/manager_pgsql.php diff -u pear/MDB/manager_pgsql.php:1.2 pear/MDB/manager_pgsql.php:1.3 --- pear/MDB/manager_pgsql.php:1.2 Thu Jul 4 15:10:47 2002 +++ pear/MDB/manager_pgsql.php Wed Jul 10 07:17:42 2002 @@ -42,7 +42,7 @@ // | Author: Paul Cooper <pgc@ucecom.com> | // +----------------------------------------------------------------------+ // -// $Id: manager_pgsql.php,v 1.2 2002/07/04 19:10:47 lsmith Exp $ +// $Id: manager_pgsql.php,v 1.3 2002/07/10 11:17:42 lsmith Exp $ // // MDB postgresql driver class for RDBMS management methods. // @@ -203,7 +203,7 @@ * * @return mixed DB_OK on success, a DB error on failure */ - function listViewss(&$db, &$tables) + function listViews(&$db, &$tables) { // gratuitously stolen from PEAR DB _getSpecialQuery in pgsql.php $result = $db->query("SELECT viewname FROM pg_views"); @@ -213,14 +213,16 @@ return $db->fetchCol($result, $viewss); } - function createSequence(&$db, $name, $start) + function createSequence(&$db, $seq_name, $start) { - return($db->query("CREATE SEQUENCE $name INCREMENT 1" . ($start < 1 ? " MINVALUE $start" : "")." START $start")); + $seqname = $db->getSequenceName($seq_name); + return($db->query("CREATE SEQUENCE $seqname INCREMENT 1" . ($start < 1 ? " MINVALUE $start" : "")." START $start")); } - function dropSequence(&$db, $name) + function dropSequence(&$db, $seq_name) { - return($db->query("DROP SEQUENCE $name")); + $seqname = $db->getSequenceName($seq_name); + return($db->query("DROP SEQUENCE $seq_name")); } };