[teiid-issues] [JBoss JIRA] (TEIID-5220) Add support for information_schema namespace
Steven Hawkins (JIRA)
issues at jboss.org
Thu Mar 8 11:08:00 EST 2018
[ https://issues.jboss.org/browse/TEIID-5220?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins resolved TEIID-5220.
-----------------------------------
Resolution: Done
Added the information_schema views under the pg_catalog. In addition to the columns shown above it appears that is_updatable was needed on the columns view.
> 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)
More information about the teiid-issues
mailing list