I've recently been evaluating Teiid to be used as common data gateway for multiple datasources for BI tools like tableau and powerbi. I was able to get connection to work with a ODBC File DSN for Powerbi, but having a hard time getting the DSN less connection or the ProgresSQL Driver to work. Came across NPGSql library for DotNet projects, but when it establishes a connection with Teiid (session is successfully created in teiid), it immediately issues the following sql command

SELECT ns.nspname, a.typname, a.oid, a.typrelid, a.typbasetype,

CASE WHEN pg_proc.proname = 'array_recv' THEN 'a'

ELSE a.typtype

END AS type,

CASE WHEN pg_proc.proname = 'array_recv' THEN a.typelem

ELSE 0

END AS elemoid,

CASE WHEN pg_proc.proname IN ('array_recv', 'oidvectorrecv') THEN 3

WHEN a.typtype = 'r' THEN 2

WHEN a.typtype = 'd' THEN 1

ELSE 0

END AS ord

FROM ((pg_type AS a INNER JOIN pg_namespace AS ns ON ns.oid = a.typnamespace) INNER JOIN pg_proc ON pg_proc.oid = a.typreceive)

LEFT OUTER JOIN pg_type AS b ON b.oid = a.typelem

WHERE ((a.typtype IN ('b', 'r', 'e', 'd')) AND ((b.typtype IS NULL) OR (b.typtype IN ('b', 'r', 'e', 'd')))) OR ((a.typname IN ('record', 'void')) AND (a.typtype = 'p')) ORDER BY ord

The connection ends up terminating because the column "typreceive" is not currently supported in Teiid. Would it be possible to add support for  missing columns from the pg_type table (https://www.postgresql.org/docs/9.2/static/catalog-pg-type.html)

I understand the issue is with the provider sending this command, but would great is these columns would be supported

Work around is to use the ODBC drive from ProgresSQL and create a file DSN.