[teiid-issues] [JBoss JIRA] (TEIID-5624) Implement LO function support for pg/ODBC

[Steven Hawkins (Jira)]

    [ https://issues.jboss.org/browse/TEIID-5624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13711004#comment-13711004 ] 

Steven Hawkins commented on TEIID-5624:
---------------------------------------

Using the pg jdbc client for reference we need lo_open loread lo_close lo_lseek to implement read-only lobs.  The pg_proc table will need to be updated with these methods.  The easiest way to do that is to add pg_catalog functions to the pg_proc table.  The full function sub-protocol will need to be implemented, but we can restrict to only these functions.

> Implement LO function support for pg/ODBC
> -----------------------------------------
>
>                 Key: TEIID-5624
>                 URL: https://issues.jboss.org/browse/TEIID-5624
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: ODBC
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>            Priority: Major
>             Fix For: 12.2
>
>
> The current logic maps lobs to bytea and text types and caps their length by default to 2MB.  We should add actual lob support using the LO functions.



--
This message was sent by Atlassian Jira
(v7.12.1#712002)