| 7 | 0.0035 | 600520 | errorHandler( $errno = 256, $errstr = 'Unable to connect to postgres9 database', $errfile = '/inet/www/intranet-6/includes/lib/data/DB.class.php', $errline = 58, ['which' => 'adodb', 'database' => 'intranet-6', 'dbServer' => '/var/run/postgresql/:5434', 'dbUsername' => 'cecsinet', 'dbPassword' => 'resetlight', 'dbType' => 'postgres9', 'default_fetch_mode' => 2, 'adodb' => class ADODB_postgres9 { public $databaseType = 'postgres9'; public $metaDefaultsSQL = 'SELECT d.adnum as num, pg_get_expr(d.adbin, d.adrelid) as def\n\t\tFROM pg_attrdef d, pg_class c \n\t\tWHERE d.adrelid=c.oid AND c.relname=\'%s\' \n\t\tORDER BY d.adnum'; public $hasLimit = TRUE; public $ansiOuter = TRUE; public $charSet = TRUE; public $metaColumnsSQL = '\n\t\tSELECT\n\t\t\ta.attname,\n\t\t\tCASE\n\t\t\t\tWHEN x.sequence_name != \'\'\n\t\t\t\tTHEN \'SERIAL\'\n\t\t\t\tELSE t.typname\n\t\t\tEND AS typname,\n\t\t\ta.attlen, a.atttypmod, a.attnotnull, a.atthasdef, a.attnum\n\t\tFROM\n\t\t\tpg_class c,\n\t\t\tpg_attribute a\n\t\tJOIN pg_type t ON a.atttypid = t.oid\n\t\tLEFT JOIN (\n\t\t\tSELECT\n\t\t\t\tc.relname as sequence_name,\n\t\t\t\tc1.relname as related_table,\n\t\t\t\ta.attname as related_column\n\t\t\tFROM pg_class c\n\t\t\tJOIN pg_depend d ON d.objid'; public $metaColumnsSQL1 = '\n\t\tSELECT\n\t\t\ta.attname,\n\t\t\tCASE\n\t\t\t\tWHEN x.sequence_name != \'\'\n\t\t\t\tTHEN \'SERIAL\'\n\t\t\t\tELSE t.typname\n\t\t\tEND AS typname,\n\t\t\ta.attlen, a.atttypmod, a.attnotnull, a.atthasdef, a.attnum\n\t\tFROM\n\t\t\tpg_class c,\n\t\t\tpg_namespace n,\n\t\t\tpg_attribute a\n\t\tJOIN pg_type t ON a.atttypid = t.oid\n\t\tLEFT JOIN (\n\t\t\tSELECT\n\t\t\t\tc.relname as sequence_name,\n\t\t\t\tc1.relname as related_table,\n\t\t\t\ta.attname as related_column\n\t\t\tFROM pg_class c\n\t\t\tJOIN'; public $dataProvider = 'postgres'; public $hasInsertID = TRUE; public $_resultid = FALSE; public $concat_operator = '||'; public $metaDatabasesSQL = 'select datname from pg_database where datname not in (\'template0\',\'template1\') order by 1'; public $metaTablesSQL = 'select tablename,\'T\' from pg_tables where tablename not like \'pg\\_%\'\n\t\tand tablename not in (\'sql_features\', \'sql_implementation_info\', \'sql_languages\',\n\t\t\t\'sql_packages\', \'sql_sizing\', \'sql_sizing_profiles\')\n\tunion\n\t\tselect viewname,\'V\' from pg_views where viewname not like \'pg\\_%\''; public $isoDates = TRUE; public $sysDate = 'CURRENT_DATE'; public $sysTimeStamp = 'CURRENT_TIMESTAMP'; public $blobEncodeType = 'C'; public $metaKeySQL = 'SELECT ic.relname AS index_name, a.attname AS column_name,i.indisunique AS unique_key, i.indisprimary AS primary_key\n\t\tFROM pg_class bc, pg_class ic, pg_index i, pg_attribute a\n\t\tWHERE bc.oid = i.indrelid AND ic.oid = i.indexrelid\n\t\tAND (i.indkey[0] = a.attnum OR i.indkey[1] = a.attnum OR i.indkey[2] = a.attnum OR i.indkey[3] = a.attnum OR i.indkey[4] = a.attnum OR i.indkey[5] = a.attnum OR i.indkey[6] = a.attnum OR i.indkey[7] = a.attnum)\n\t\tAND a.attrelid = bc.oid AND bc.relname = \'%s\''; public $hasAffectedRows = TRUE; public $true = 'TRUE'; public $false = 'FALSE'; public $fmtDate = '\'Y-m-d\''; public $fmtTimeStamp = '\'Y-m-d H:i:s\''; public $hasMoveFirst = TRUE; public $hasGenID = TRUE; public $_genIDSQL = 'SELECT NEXTVAL(\'%s\')'; public $_genSeqSQL = 'CREATE SEQUENCE %s START %s'; public $_dropSeqSQL = 'DROP SEQUENCE %s'; public $random = 'random()'; public $autoRollback = TRUE; public $uniqueIisR = TRUE; public $_bindInputArray = TRUE; public $disableBlobs = FALSE; public $_pnum = 0; public $database = 'intranet-6'; public $host = '/var/run/postgresql/:5434'; public $port = ''; public $user = 'cecsinet'; public $password = 'not stored'; public $debug = FALSE; public $maxblobsize = 262144; public $substr = 'substr'; public $length = 'length'; public $upperCase = 'upper'; public $replaceQuote = '\\\''; public $nameQuote = '"'; public $uniqueOrderBy = FALSE; public $emptyDate = ' '; public $emptyTimeStamp = ' '; public $lastInsID = FALSE; public $hasTop = FALSE; public $readOnly = FALSE; public $hasTransactions = TRUE; public $genID = 0; public $raiseErrorFn = FALSE; public $cacheSecs = 3600; public $memCache = FALSE; public $memCacheHost = NULL; public $memCachePort = 11211; public $memCacheCompress = FALSE; public $sysUTimeStamp = FALSE; public $arrayClass = 'ADORecordSet_array'; public $noNullStrings = FALSE; public $numCacheHits = 0; public $numCacheMisses = 0; public $pageExecuteCountRows = TRUE; public $uniqueSort = FALSE; public $leftOuter = FALSE; public $rightOuter = FALSE; public $poorAffectedRows = FALSE; public $fnExecute = FALSE; public $fnCacheExecute = FALSE; public $rsPrefix = 'ADORecordSet_'; public $autoCommit = TRUE; public $transOff = 0; public $transCnt = 0; public $fetchMode = 2; public $null2null = 'null'; public $bulkBind = FALSE; public $_oldRaiseFn = FALSE; public $_transOK = NULL; public $_connectionID = FALSE; public $_errorMsg = 'Database connection failed'; public $_errorCode = FALSE; public $_queryID = FALSE; public $_isPersistentConnection = FALSE; public $_evalAll = FALSE; public $_affected = FALSE; public $_logsql = FALSE; public $_transmode = ''; protected $connectionParameters = [...] }, 'adodb_ret' => FALSE] ) | .../DB.class.php:58 |