[teiid-issues] [JBoss JIRA] (TEIID-5236) Document and update GeoServer compatibility

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-5236:
---------------------------------------

There are two statements issued from the PG JDBC TypeInfoCache that are problematic.  One can be satisfied by implementing current_schemas.  The other requires implementing:

generate_series table valued function
array_upper (similar to array_length for the first dimension)
natural join (with an explicit column list)

We'll also need to populate the typinput column from pg_type.  It may be easier to just add a full override of the expected sql.

> Document and update GeoServer compatibility
> -------------------------------------------
>
>                 Key: TEIID-5236
>                 URL: https://issues.jboss.org/browse/TEIID-5236
>             Project: Teiid
>          Issue Type: Quality Risk
>          Components: Documentation, ODBC, Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 10.2
>
>
> It is not documented on the geoserver integration page, but most of the initial work was done against versions between 2.6 and 2.8.  It appears that even 2.8 can have issues as it can use the 9.4 postgresql driver, which expects additional syntax support for type metadata.



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)