[teiid-issues] [JBoss JIRA] (TEIID-4493) Add support for integration with qgis

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-4493:
---------------------------------------

Changing the postgis version also has a lot of effect on what queries are issued.  1.4, 1.5, and 2.0+ all have different behavior with qgis.  Support below 2.0 means that most geometry functions will be accessed by the old name, e.g extent vs. st_extent - which will need rewrite support for proper push down handling.

We additional need to support a two argument form of (st_)asBinary.  I've also added dummy implementations of, pg_inherits, pg_stats, and pg_geography_columns.

Even with the changes outlined in these comments that's not quite enough for things to work.  qgis will define a layer, but on validation warns that each value has "Unknown geometry type 0".

I'll give this another day or two, then at least commit the enhancements.  Beyond that we'll likely defer full support until there is a customer/product request.

> Add support for integration with qgis 
> --------------------------------------
>
>                 Key: TEIID-4493
>                 URL: https://issues.jboss.org/browse/TEIID-4493
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Documentation, Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 9.2
>
>
> Similar to our support for GeoServer, we should support qgis integration if possible.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)