[teiid-issues] [JBoss JIRA] (TEIID-5498) Allow the pg layer to work for simple selects with the postgres_fdw

[Steven Hawkins (Jira)]

     [ https://issues.jboss.org/browse/TEIID-5498?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-5498.
-----------------------------------
    Resolution: Done


Simple types and their array variations will work just fine.  The standard pg/odbc issues remain:

- the cursor select is under a transaction
- the object type is not supported
- multi-dimensional arrays are not supported
- lobs are inline in the resultset and limited in size

> 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)