[
https://issues.jboss.org/browse/TEIID-5220?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-5220:
---------------------------------------
It's not a problem to add the tables/views views. However columns conveys type
information that is pg system metadata specific. So for now I'm thinking this will
need to go under the pg catalog metadata as prefixed views -
pg_catalog."information_schema.columns". This will still resolve as expected if
the client uses information_schema.columns. The only potential issue is that the user
could add an information_schema model/schema to the vdb and redirect these queries.
Add support for information_schema namespace
--------------------------------------------
Key: TEIID-5220
URL:
https://issues.jboss.org/browse/TEIID-5220
Project: Teiid
Issue Type: Bug
Components: ODBC, Query Engine
Reporter: Divyesh Vallabh
Assignee: Steven Hawkins
Fix For: 10.2
The npgsql provider uses the the infomation_schema namespace to query meta information
for tables and views.
Add support for information_schema.tables (
https://www.postgresql.org/docs/10/static/infoschema-tables.html) to teiid
Add support for information_schema.views (
https://www.postgresql.org/docs/10/static/infoschema-views.html) to teiid
Add support for information_schema.columns (
https://www.postgresql.org/docs/10/static/infoschema-columns.html) to teiid
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)