]
Steven Hawkins resolved TEIID-5140.
-----------------------------------
Fix Version/s: 10.0.3
(was: 10.0.1)
Resolution: Done
This is partially resolved for 10.0.1. The latest fix also adds TYPE and SEQUENCE table
types to be omitted as tables.
Teiid 10 postgres driver version
--------------------------------
Key: TEIID-5140
URL:
https://issues.jboss.org/browse/TEIID-5140
Project: Teiid
Issue Type: Bug
Components: Documentation, JDBC Connector, ODBC
Reporter: Lukáš Svačina
Assignee: Steven Hawkins
Fix For: 10.1, 10.0.3
I tried several drivers from
https://jdbc.postgresql.org/download.html and figured out
that 9.4-1203 JDBC 42 is the newest working driver for my application.
Newer drivers cause Teiid to fail on datasource creation with error
"Reason:TEIID60011 No column found on table xxxx.pg_toast.pg_toast_16446 with name
chunk_id"
Please update docs about what driver version is recommended (or tested) and if there is
any reason to update to newer postgres drivers (what benefits it brings and how teiid uses
it).
Might be good idea to ship driver within teiid package or at least keep updated
_docs\teiid\datasources\postgresql\readme.txt_ to contain recommended driver name.