Support for column typreceive in pg_type

[dvallabh_doi]

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.

[shawkins]

> but having a hard time getting the DSN less connection or the ProgresSQL Driver to work

Can you clarify if that is due to the BI tool, driver, or Teiid?

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

Yes, it is possible to add support.  We strive to support the most commonly used clients.  Can you create an issue for this: - JBoss Issue Tracker

[dvallabh_doi]

>  Can you clarify if that is due to the BI tool, driver, or Teiid?

If support for missing columns in the pg_type table are added then it should resolve the issue with using NpgSQL driver in dotnet projects to connect to a Teiid VBD

I went ahead created a ticket for this issue in the jboss tracker