New York Center for Structural Genomics

Warning (2): pg_pconnect() [function.pg-pconnect]: Unable to connect to PostgreSQL server: could not translate host name "labdb" to address: Name or service not known [CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 122]

Code | Context

            $this->connection = pg_connect($conn, PGSQL_CONNECT_FORCE_NEW);
        } else {
            $this->connection = pg_pconnect($conn);

$config	=	array(
	"persistent" => true,
	"host" => "*****",
	"login" => "*****",
	"password" => "*****",
	"database" => "*****",
	"schema" => "*****",
	"port" => "*****",
	"encoding" => "utf8",
	"sslmode" => "prefer",
	"driver" => "postgres",
	"prefix" => "*****"
)
$conn	=	"host='labdb' port='5432' dbname='labdb_aecom' user='lab_interface' password='l4b_interface' sslmode='prefer'"

pg_pconnect - [internal], line ??
DboPostgres::connect() - CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 122
DboSource::__construct() - CORE/cake/libs/model/datasources/dbo_source.php, line 144
ConnectionManager::getDataSource() - CORE/cake/libs/model/connection_manager.php, line 114
Model::setDataSource() - CORE/cake/libs/model/model.php, line 2863
Model::__construct() - CORE/cake/libs/model/model.php, line 478
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142

Warning (2): pg_set_client_encoding() expects parameter 1 to be resource, boolean given [CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 987]

Code | Context

 */
    function setEncoding($enc) {
        return pg_set_client_encoding($this->connection, $enc) == 0;

$enc	=	"utf8"

pg_set_client_encoding - [internal], line ??
DboPostgres::setEncoding() - CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 987
DboPostgres::connect() - CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 131
DboSource::__construct() - CORE/cake/libs/model/datasources/dbo_source.php, line 144
ConnectionManager::getDataSource() - CORE/cake/libs/model/connection_manager.php, line 114
Model::setDataSource() - CORE/cake/libs/model/model.php, line 2863
Model::__construct() - CORE/cake/libs/model/model.php, line 478
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69

Warning (2): pg_query() expects parameter 1 to be resource, boolean given [CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 169]

Code | Context

 */
    function _execute($sql) {
        return pg_query($this->connection, $sql);

$sql	=	"SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'hkldb' OR table_schema = 'pepdb' OR table_schema = 'xtaldb' OR table_schema = 'public';"

pg_query - [internal], line ??
DboPostgres::_execute() - CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 169
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 254
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 411
DboPostgres::listSources() - CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 187
Model::setSource() - CORE/cake/libs/model/model.php, line 777
Model::__construct() - CORE/cake/libs/model/model.php, line 483
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69

Warning (2): pg_last_error() expects parameter 1 to be resource, boolean given [CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 462]

Code

 */
    function lastError() {
        $error = pg_last_error($this->connection);

pg_last_error - [internal], line ??
DboPostgres::lastError() - CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 462
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 258
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 411
DboPostgres::listSources() - CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 187
Model::setSource() - CORE/cake/libs/model/model.php, line 777
Model::__construct() - CORE/cake/libs/model/model.php, line 483
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69

Warning (2): Cannot modify header information - headers already sent by (output started at /var/www/cakephp-1.3-git/cake/libs/debugger.php:686) [CORE/cake/libs/controller/controller.php, line 742]

Code | Context

 */
    function header($status) {
        header($status);

$status	=	"HTTP/1.0 500 Internal Server Error"

header - [internal], line ??
Controller::header() - CORE/cake/libs/controller/controller.php, line 742
ErrorHandler::missingTable() - CORE/cake/libs/error.php, line 254
Object::dispatchMethod() - CORE/cake/libs/object.php, line 112
ErrorHandler::__construct() - CORE/cake/libs/error.php, line 125
Object::cakeError() - CORE/cake/libs/object.php, line 201
Model::setSource() - CORE/cake/libs/model/model.php, line 783
Model::__construct() - CORE/cake/libs/model/model.php, line 483
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491

Notice (8): Undefined index: view_contact_only [/var/www/unitrack/views/helpers/unitrack_actions.php, line 236]

Code | Context

<div class="leftnav">

<?php $actions->create(isset($this->params['pass'][0])?$this->params['pass'][0]:null);?>

$id	=	"000665"
$addIcon	=	"<img src="/nysgrc/img/Fwdw_icons/standart/png/24x24/001_01.png?1287178386" alt="" />"
$listIcon	=	"<img src="/nysgrc/img/Fwdw_icons/standart/png/24x24/001_61.png?1287178386" alt="" />"
$deleteIcon	=	"<img src="/nysgrc/img/Fwdw_icons/standart/png/24x24/001_02.png?1287178386" alt="" />"
$editIcon	=	"<img src="/nysgrc/img/Fwdw_icons/standart/png/24x24/001_45.png?1287178386" alt="" />"
$loginIcon	=	"<img src="/nysgrc/img/Fwdw_icons/standart/png/24x24/001_59.png?1287178386" alt="" />"
$logoutIcon	=	"<img src="/nysgrc/img/Fwdw_icons/standart/png/24x24/001_51.png?1287178386" alt="" />"
$cancelIcon	=	"<img src="/nysgrc/img/Fwdw_icons/standart/png/24x24/001_05.png?1287178386" alt="" />"
$okIcon	=	"<img src="/nysgrc/img/Fwdw_icons/standart/png/24x24/001_06.png?1287178386" alt="" />"
$settingsIcon	=	"<img src="/nysgrc/img/Fwdw_icons/standart/png/24x24/001_41.png?1287178386" alt="" />"
$bugIcon	=	"<img src="/nysgrc/img/Fwdw_icons/standart/png/24x24/001_50.png?1287178386" alt="" />"
$menuIcon	=	"<img src="/nysgrc/img/Fwdw_icons/standart/png/24x24/001_20.png?1287178386" alt="" />"
$lockIcon	=	"<img src="/nysgrc/img/Fwdw_icons/standart/png/24x24/001_42.png?1287178386" alt="" />"
$warningIcon	=	"<img src="/nysgrc/img/Fwdw_icons/standart/png/24x24/001_11.png?1287178386" alt="" />"
$internalIcon	=	"<img src="/nysgrc/img/Fwdw_icons/standart/png/24x24/001_37.png?1287178386" alt="" />"
$treen	=	array(
	"Target" => "Protein Clone",
	"Protein Clone" => "Expression",
	"ProteinClone" => "Expression",
	"Expression" => "Purification",
	"Purification" => "Crystallization Drop",
	"Crystallization Drop" => "Crystal Harvest",
	"CrystallizationDrop" => "Crystal Harvest",
	"Crystal Harvest" => "Dataset",
	"CrystalHarvest" => "Dataset"
)
$tree	=	array(
	"Target" => "protein_clones",
	"Protein Clone" => "expressions",
	"ProteinClone" => "expressions",
	"Expression" => "purifications",
	"Purification" => "crystallization_drops",
	"Crystallization Drop" => "crystal_harvests",
	"CrystallizationDrop" => "crystal_harvests",
	"Crystal Harvest" => "datasets",
	"CrystalHarvest" => "datasets"
)
$view	=	View
View::$base = "/nysgrc"
View::$here = "/nysgrc/subtargets/index/000665"
View::$plugin = NULL
View::$name = "CakeError"
View::$action = NULL
View::$params = array
View::$passedArgs = array
View::$data = array
View::$helpers = array
View::$viewPath = "errors"
View::$viewVars = array
View::$layout = "default"
View::$layoutPath = NULL
View::$autoRender = true
View::$autoLayout = true
View::$ext = ".ctp"
View::$subDir = NULL
View::$theme = NULL
View::$cacheAction = false
View::$validationErrors = array
View::$hasRendered = false
View::$loaded = array
View::$modelScope = false
View::$model = NULL
View::$association = NULL
View::$field = NULL
View::$fieldSuffix = NULL
View::$modelId = NULL
View::$uuids = array
View::$output = false
View::$__passedVars = array
View::$__scripts = array
View::$__paths = array
View::$webroot = "/nysgrc/"
View::$Form = FormHelper object
View::$Javascript = JavascriptHelper object
View::$Ajax = AjaxHelper object
View::$Session = SessionHelper object
View::$Html = HtmlHelper object
View::$Actions = ActionsHelper object
$RequestPerson	=	RequestPerson
RequestPerson::$name = "RequestPerson"
RequestPerson::$useTable = "request_person"
RequestPerson::$primaryKey = "person_id"
RequestPerson::$hasMany = array
RequestPerson::$validate = array
RequestPerson::$actsAs = array
RequestPerson::$useDbConfig = "default"
RequestPerson::$displayField = "person_id"
RequestPerson::$id = false
RequestPerson::$data = array
RequestPerson::$table = "request_person"
RequestPerson::$_schema = array
RequestPerson::$validationErrors = array
RequestPerson::$tablePrefix = ""
RequestPerson::$alias = "RequestPerson"
RequestPerson::$tableToModel = array
RequestPerson::$logTransactions = false
RequestPerson::$cacheQueries = false
RequestPerson::$belongsTo = array
RequestPerson::$hasOne = array
RequestPerson::$hasAndBelongsToMany = array
RequestPerson::$Behaviors = BehaviorCollection object
RequestPerson::$whitelist = array
RequestPerson::$cacheSources = true
RequestPerson::$findQueryType = NULL
RequestPerson::$recursive = 1
RequestPerson::$order = NULL
RequestPerson::$virtualFields = array
RequestPerson::$__associationKeys = array
RequestPerson::$__associations = array
RequestPerson::$__backAssociation = array
RequestPerson::$__insertID = NULL
RequestPerson::$__numRows = NULL
RequestPerson::$__affectedRows = NULL
RequestPerson::$__safeUpdateMode = false
RequestPerson::$_findMethods = array
RequestPerson::$RequestTarget = RequestTarget object
RequestPerson::$queriesLogMax = 700
$user	=	false
$is_requester	=	false
$center_id	=	"NYSGRC"
$classname	=	"actions_menu"

Unitrack_ActionsHelper::create() - /var/www/unitrack/views/helpers/unitrack_actions.php, line 236
include - APP/views/layouts/default.ctp, line 81
View::_render() - CORE/cake/libs/view/view.php, line 736
View::renderLayout() - CORE/cake/libs/view/view.php, line 494
View::render() - CORE/cake/libs/view/view.php, line 440
Controller::render() - CORE/cake/libs/controller/controller.php, line 909
ErrorHandler::_outputMessage() - CORE/cake/libs/error.php, line 458
ErrorHandler::missingTable() - CORE/cake/libs/error.php, line 261
Object::dispatchMethod() - CORE/cake/libs/object.php, line 112
ErrorHandler::__construct() - CORE/cake/libs/error.php, line 125
Object::cakeError() - CORE/cake/libs/object.php, line 201
Model::setSource() - CORE/cake/libs/model/model.php, line 783
Model::__construct() - CORE/cake/libs/model/model.php, line 483
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491

Missing Database Table

Error: Database table person for model LabdbUser was not found.

Trace:

include - /var/www/unitrack/views/errors/unitrack_missing_table.ctp, line 9
include - APP/views/errors/missing_table.ctp, line 1
View::_render() - CORE/cake/libs/view/view.php, line 736
View::render() - CORE/cake/libs/view/view.php, line 431
Controller::render() - CORE/cake/libs/controller/controller.php, line 909
ErrorHandler::_outputMessage() - CORE/cake/libs/error.php, line 458
ErrorHandler::missingTable() - CORE/cake/libs/error.php, line 261
Object::dispatchMethod() - CORE/cake/libs/object.php, line 112
ErrorHandler::__construct() - CORE/cake/libs/error.php, line 125
Object::cakeError() - CORE/cake/libs/object.php, line 201
Model::setSource() - CORE/cake/libs/model/model.php, line 783
Model::__construct() - CORE/cake/libs/model/model.php, line 483
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Controller::loadModel() - CORE/cake/libs/controller/controller.php, line 637
Controller::constructClasses() - CORE/cake/libs/controller/controller.php, line 502
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 186
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83

(default) 32 queries took 75 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';	109	109	14
2	SELECT matviewname as name FROM pg_matviews;	0	0	1
3	SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';	109	109	3
4	SELECT matviewname as name FROM pg_matviews;	0	0	1
5	SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';	109	109	3
6	SELECT matviewname as name FROM pg_matviews;	0	0	1
7	SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';	109	109	3
8	SELECT matviewname as name FROM pg_matviews;	0	0	1
9	SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';	109	109	3
10	SELECT matviewname as name FROM pg_matviews;	0	0	1
11	SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';	109	109	3
12	SELECT matviewname as name FROM pg_matviews;	0	0	1
13	SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';	109	109	3
14	SELECT matviewname as name FROM pg_matviews;	0	0	1
15	SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';	109	109	3
16	SELECT matviewname as name FROM pg_matviews;	0	0	1
17	SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';	109	109	3
18	SELECT matviewname as name FROM pg_matviews;	0	0	1
19	SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';	109	109	3
20	SELECT matviewname as name FROM pg_matviews;	0	0	1
21	SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';	109	109	3
22	SELECT matviewname as name FROM pg_matviews;	0	0	1
23	SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';	109	109	3
24	SELECT matviewname as name FROM pg_matviews;	0	0	1
25	SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';	109	109	3
26	SELECT matviewname as name FROM pg_matviews;	0	0	1
27	SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';	109	109	3
28	SELECT matviewname as name FROM pg_matviews;	0	0	1
29	SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';	109	109	3
30	SELECT matviewname as name FROM pg_matviews;	0	0	1
31	SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';	109	109	3
32	SELECT matviewname as name FROM pg_matviews;	0	0	1

(default) 32 queries took 75 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

(labdb) 2 queries took 2 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'hkldb' OR table_schema = 'pepdb' OR table_schema = 'xtaldb' OR table_schema = 'public';				2
2	SELECT matviewname as name FROM pg_matviews;				0

(labdb) 2 queries took 2 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'hkldb' OR table_schema = 'pepdb' OR table_schema = 'xtaldb' OR table_schema = 'public';

SELECT matviewname as name FROM pg_matviews;