[teiid-issues] [JBoss JIRA] (TEIID-5226) Error when inserting a Geometry value into PostgreSQL

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-5226.
-----------------------------------
    Fix Version/s: 10.1
                   10.0.3
       Resolution: Done


The parameter logic needed to account for the srid and use ST_GEOMFROMWKB function as well.

That does leave one case though unaccounted for - stored procedure parameters are limited in their ability currently to specify expressions, so using a function is not currently possible without some additional refactoring.  This is something that we could work around for just postgresql by using an implicitly convertible character string or binary string format.  However other databases do not support ewkb, so that's not a general solution.

> Error when inserting a Geometry value into PostgreSQL
> -----------------------------------------------------
>
>                 Key: TEIID-5226
>                 URL: https://issues.jboss.org/browse/TEIID-5226
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Connector
>    Affects Versions: 8.12.12.6_3
>            Reporter: Madou Coulibaly
>            Assignee: Steven Hawkins
>             Fix For: 10.1, 10.0.3
>
>         Attachments: server.log
>
>
> Inserting a Geometry value into a PostgreSQL database using Teiid raises an error:
> ERROR: Geometry SRID (0) does not match column SRID (28992)
> Seems we do not take in account the SRID value during this operation.



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