[teiid-issues] [JBoss JIRA] (TEIID-5498) Allow the pg layer to work for simple selects with the postgres_fdw
Steven Hawkins (Jira)
issues at jboss.org
Fri Oct 5 07:53:00 EDT 2018
[ https://issues.jboss.org/browse/TEIID-5498?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13643895#comment-13643895 ]
Steven Hawkins commented on TEIID-5498:
---------------------------------------
The initial commit is. I'll do more testing with a variety of types. We may also need to add enforcement of metadata constraints - such as string length - as to ensure proper results. That would be similar to existing logic in odata.
This is also not a general purpose solution yet as including predicates can result in sql that isn't yet valid for us, such as using pg type names in casts 'a'::text - most of those issues would be easy to address though.
> Allow the pg layer to work for simple selects with the postgres_fdw
> -------------------------------------------------------------------
>
> Key: TEIID-5498
> URL: https://issues.jboss.org/browse/TEIID-5498
> Project: Teiid
> Issue Type: Sub-task
> Components: ODBC
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 11.2
>
>
> Another avenue for materialization support outlined in TEIID-4251 is to rely upon pg materialization, which would be easiest to setup through their foreign data wrapper. However it expects some additional support for:
> start transaction syntax
> abort transaction
> automatic cleanup of portals/cursors at the end of a transaction
> prepared cursors
> Additionally this will have the same performance issue that we have with declare/fetch initially - that is a cursor requires a transaction, and our current strategy requires pre-buffering the results under a transaction. However since this would only be used for load/refresh that performance hit may be negligible - if now we'd need similar logic to effectively ignore the transaction wrapping.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
More information about the teiid-issues
mailing list