[ https://issues.jboss.org/browse/TEIID-5220?page=com.atlassian.jira.plugin... ] Salvatore R. edited comment on TEIID-5220 at 8/19/19 5:30 AM: -------------------------------------------------------------- [~shawkins] I have another question about the current implementation, please. Accordingly to the PostgreSQL docs mentioned in the description, VIEWS and TABLES should return respectively: - TABLES: all tables and views - VIEWS: only views but it seems that the current implementation in Teiid returns both tables and views for information_schema.TABLES but only tables (and not views) in information_schema.VIEWS. Looking at the code, the view transformation is indeed defined as: {code:sql}select vdbname, schemaName, name, 'NONE', case when SupportsUpdates then 'YES' else 'NO' end from sys.tables where IsPhysical{code} Is there any reason why it is implemented this way or is it maybe a bug? :) was (Author: fox123): [~shawkins] I have another question about the current implementation, please. Accordingly to the PostgreSQL docs mentioned in the description, VIEWS and TABLES should return respectively: - TABLES: all tables and views - VIEWS: only views but it seems that the current implementation in Teiid returns both tables and views for information_schema.TABLES but only tables (and not views) in information_schema.VIEWS. Looking at the code, the view transformation is indeed defined as: {code:sql}select vdbname, schemaName, name, 'NONE', case when SupportsUpdates then 'YES' else 'NO' end from sys.tables where IsPhysical{code}. Is there any reason why it is implemented or is it maybe a bug? :) -- This message was sent by Atlassian Jira (v7.12.1#712002)