[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:comment-tabpanel&focusedCommentId=13522709#comment-13522709 ] 

Steven Hawkins commented on TEIID-5226:
---------------------------------------

This is an issue when using a non-literal binding, such as an insert with a query expression:

insert into geotable (the_geom, name) select the_geom, name from #tempGeo

Issuing 

insert into geotable (the_geom, name) values (st_setsrid(st_point(1,1), 432), 'a')

will work as expected because the translator uses ST_GEOMFROMWKB and passes the srid from the literal value as an argument.

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