[teiid-issues] [JBoss JIRA] (TEIID-5201) Update teiid pg_type schema to match PostgreSQL pg_type in support of NPGsql provider

[Divyesh Vallabh (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-5201?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Divyesh Vallabh updated TEIID-5201:
-----------------------------------
    Description: 
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





  was:
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.constraint (https://www.postgresql.org/docs/9.2/static/catalog-pg-constraint.html) to teiid







> 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
>
> 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)