极湖

SELECT sequence_name FROM information_schema.sequences

SELECT c.relname as sequence_name FROM pg_catalog.pg_class c, pg_catalog.pg_namespace n WHERE c.relnamespace = n.oid AND c.relkind='S' and n.nspname = 'public'

    function sequenceExists($seq) {
        $cache = parent::__cacheDescription('sequences');
        if($cache != null) {
            return in_array($seq, $cache);
        }
        $sequences = array();
        // ★修改这句
        //$res = $this->rawQuery("SELECT sequence_name FROM information_schema.sequences");
        $schema = $this->config['schema'];
        $res = $this->rawQuery("SELECT c.relname as sequence_name FROM pg_catalog.pg_class c, pg_catalog.pg_namespace n WHERE c.relnamespace = n.oid AND c.relkind='S' AND n.nspname = '{$schema}'");
        while($row = $this->fetchRow($res)) {
            $sequences[] = $row[0]['sequence_name'];
        }
        
        parent::__cacheDescription('sequences', $sequences);
        return in_array($seq, $sequences);
    }

<?php
class DATABASE_CONFIG {
    #localhost
    var $local = array('driver' => 'mysql',
        'connect' => 'mysql_connect',
        'host' => 'localhost',
        'login' => 'root',
        'password' => ",
        'database' => 'local',
        'prefix' => '');

    #dev server
    var $dev = array('driver' => 'mysql',
        'connect' => 'mysql_connect',
        'host' => 'mysql.dev.com',
        'login' => 'dev',
        'password' => 'password',
        'database' => 'dev',
        'prefix' => '');

    #live server
    var $live = array('driver' => 'mysql',
        'connect' => 'mysql_connect',
        'host' => 'mysql.live.com',
        'login' => 'live',
        'password' => 'password',
        'database' => 'live',
        'prefix' => ");

    #switch between configs
    var $default = array();
    var $test = array();
    function __construct() {

        #wildcard the subdomains
        $host_r = explode('.', $_SERVER['SERVER_NAME']);
        if(count($host_r)>2) while(count($host_r)>2)array_shift($host_r);
        $mainhost = implode('.', $host_r);

        #switch between servers
        switch(strtolower($mainhost)) {
            case 'localhost':
                $this->default = $this->local;
                break;
            case 'dev.com':
                $this->default = $this->dev;
                break;
            case 'live.com':
                $this->default = $this->live;
                break;
            default:
                $this->default = $this->local;
        }
    }

    #php 4 compatibility
    function DATABASE_CONFIG() {
        $this->__construct();
    }
}
?>