[JBoss JIRA] (TEIID-5226) Error when inserting a Geometry value into PostgreSQL
- First Post
- Replies
- Stats
-
Go to
- ----- 2026 -----
- April
- March
- February
- January
- ----- 2025 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2024 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
https://issues.jboss.org/browse/TEIID-5226?page=com.atlassian.jira.plugin...
]
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)
2999
days inactive
2999
days old
0 comments
1 participants
tags (0)
participants (1)
-
Steven Hawkins (JIRA)