[
https://issues.jboss.org/browse/TEIID-5813?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIID-5813:
-------------------------------------
with latest deployment on OpenShift I tried `\dt` I still did not see Views in the result.
The query being sent is
{code}
SELECT n.nspname as "Schema",
c.relname as "Name",
CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN
'view' WHEN 'm' THEN 'materialized view' WHEN 'i' THEN
'index' WHEN 'S' THEN 'sequence' WHEN 's' THEN
'special' WHEN 'f' THEN 'foreign table' END as "Type",
pg_catalog.pg_get_userbyid(c.relowner) as "Owner"
FROM pg_catalog.pg_class c
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind IN ('r','')
AND n.nspname <> 'pg_catalog'
AND n.nspname <> 'information_schema'
AND n.nspname NOT LIKE_REGEX '^pg_toast'
AND pg_catalog.pg_table_is_visible(c.oid)
ORDER BY 1,2
{code}
Using the PG protocol the Virtual View schema items are not visible
-------------------------------------------------------------------
Key: TEIID-5813
URL:
https://issues.jboss.org/browse/TEIID-5813
Project: Teiid
Issue Type: Bug
Components: ODBC, Query Engine
Reporter: Ramesh Reddy
Assignee: Steven Hawkins
Priority: Major
When using PSQL client against Teiid deployed VDB, the metadata does not show the
tables/views that are defined under a virtual schema. The physical or foreign types are
visible correctly.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)