[
https://issues.jboss.org/browse/TEIID-5201?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-5201:
---------------------------------------
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.
Can you provide the log?
Looking at the Npgsql github code its referencing the
information_schema.tables, information_schema.columns and information_schema.views tables.
Ah, I had only checked on the pg_ tables mentioned in the issue. That would require an
additional system schema, so we'll have to give some thought to the ramifications.
I also noticed that it issued the following sql command
"UNLISTEN *" as well.
Ignoring an unlisten won't be problem, but if it's expecting events from listen
that would be an issue as that feature is not implemented.
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)