[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=13710566#comment-13710566 ] 

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

To emulate this behavior we need to have something like - pg_largeobject such that we assign stable oids to lob results that can then be used to look them up in the largeobject table.  It seems like we'll have to implement this on a ephemeral basis - that is for a single result it will have a set of lob oids, rather than attempting to assign oids all the way down to the source table level.

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