PostgreSQL sources do not have the procedure option within Yellowfin

Pratap Singh shared this idea ago

Idea Logged

PostgreSQL sources do not have the procedure option within Yellowfin. From what we can see this is was due to a change in PostgreSQL JDBC driver: https://github.com/pgjdbc/pgjdbc/issues/1340

In Postgres FUNCTIONs return resultsets, where in other databases, PROCEDUREs do that.

Until recently the getProcedures() call in the PostgreSQL JDBC driver would return functions from Postgres. This allowed functions that returned a resultset to be accessed by Yellowfin.

However, a recent change to the JDBC driver has stopped functions being returned by getProcedures(). This is generally returning nothing, and why the procedures option is not shown in Yellowfin.

We need to change Yellowfin to support Functions to be able to support the functionality that we used to have.