[teiid-issues] [JBoss JIRA] (TEIID-5201) Update teiid pg_type schema to match PostgreSQL pg_type in support of NPGsql provider
Divyesh Vallabh (JIRA)
issues at jboss.org
Tue Jan 16 13:26:00 EST 2018
[ https://issues.jboss.org/browse/TEIID-5201?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13517880#comment-13517880 ]
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)
More information about the teiid-issues
mailing list