From a39d9275bf2fb694560eef64d0afebecf141bc28 Mon Sep 17 00:00:00 2001 From: Nathan Gass Date: Mon, 25 Jan 2021 15:24:32 +0100 Subject: fix 850c9fd: do not presume public schema if none is given (for example temp tables have their own schema) --- it_dbi_postgres.class | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/it_dbi_postgres.class b/it_dbi_postgres.class index fd45f46..1161632 100644 --- a/it_dbi_postgres.class +++ b/it_dbi_postgres.class @@ -57,7 +57,7 @@ function _tables($p = array()) function _get_field_defs() { list($table_name, $table_schema) = array_reverse(explode('.', $this->_p['table'], 2)); - $where = $this->_where(['t.table_name' => $table_name, 't.table_schema' => $table_schema ?: 'public', 't.table_catalog' => $this->_p['db']]); + $where = $this->_where(['t.table_name' => $table_name, 't.table_catalog' => $this->_p['db']] + ($table_schema ? ['t.table_schema' => $table_schema] : [])); # Recreate Key column of mysql show columns $res = $this->query('SELECT column_name,constraint_type,ordinal_position FROM information_schema.table_constraints AS t JOIN information_schema.key_column_usage USING (constraint_name, constraint_schema, constraint_catalog) ' . $where); -- cgit v1.2.3