[teiid-issues] [JBoss JIRA] (TEIID-5504) Update pg layer for general fdw use
[
https://issues.jboss.org/browse/TEIID-5504?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-5504:
---------------------------------------
Another eventual goal would be to just reuse the pg metadata system. That is via the fdw
import all of the teiid constructs then any metadata query would be redirected to the pg
instance.
We need to valid procedures, function, and other import at a minimum. Beyond that if we
want metadata visibility to apply then pg role functions need to be aware of the teiid
role information.
Update pg layer for general fdw use
-----------------------------------
Key: TEIID-5504
URL: https://issues.jboss.org/browse/TEIID-5504
Project: Teiid
Issue Type: Enhancement
Components: ODBC
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Major
Fix For: 12.x
Building on TEIID-5498 we should allow general use of fdw access. This is much broader
in determining what function and type support is expected. At the very least type casting
needs to be aware of the pg type names as a literal like 'a' will be pushed as
'a'::text.
At this time since joins and other higher level constructs are not pushed that still
keeps the scope somewhat narrow.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)