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

If you agree I think this issue can still be marked as resolved because these changes does allow for a session to be created and queries be executed against any vdb using the npgsql provider. A separate issue can be created for tracking the information_schema support so meta information can be queried.

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, information_schema.log 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