[
https://issues.jboss.org/browse/TEIID-5201?page=com.atlassian.jira.plugin...
]
Divyesh Vallabh commented on TEIID-5201:
----------------------------------------
To test these changes with the npgsql provider I used the baby names example
(
https://developer.jboss.org/wiki/IntegrateAmazonSimpleDBWithTeiid) created by Ramesh and
you.
I was able to create a session as well as successfully query the "file.babies"
table from a powershell script I created. I'm attaching the files in case we need to
back trace how the connection test was done. [^babynametest.zip]
However, I'm still having issues with PowerBi when using the Npgsql provider. From the
Teiid logs it looks like its querying "information_schema" namespace for table
and column information.
Looking at the Npgsql github code its referencing the *information_schema.tables*,
*information_schema.columns* and *information_schema.views* tables.
I also noticed that it issued the following sql command "UNLISTEN *" as well.
Update teiid pg_type schema to match PostgreSQL pg_type in support of
NPGsql provider
-------------------------------------------------------------------------------------
Key: TEIID-5201
URL:
https://issues.jboss.org/browse/TEIID-5201
Project: Teiid
Issue Type: Bug
Components: ODBC, Query Engine
Reporter: Divyesh Vallabh
Assignee: Steven Hawkins
Attachments: babynametest.zip
When using NpgSQL provider to connect to Teiid the connection fails because the
teiid.pg_type table does not contain the column "typreceive"
Add missing columns from Postgres.pg_type
(
https://www.postgresql.org/docs/9.2/static/catalog-pg-type.html) to teiid
Add missing columns from Postgres.pg_user
(
https://www.postgresql.org/docs/9.2/static/view-pg-user.html) to teiid
Add missing columns from Postgres.pg_constraint
(
https://www.postgresql.org/docs/9.2/static/catalog-pg-constraint.html) to teiid
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)