Retrieving FOREIGN TABLEs from PostgreSQL

[gabitoju]

I'm using Saiuku with Mondrian 4 and CitusDB's cstore_fdw for storing the fact tables.

Mondrian can't retrive the FTs from Postgres and that's something very similar to this issue #354.

cstore_fdw it's a great choice for a BI solution and Mondrian should support that.

The change should be trivial, maybe somehing like this:

src/main/mondrian/gui/JdbcMetaData.java
null, dbs.name, null, new String[]{"TABLE", "VIEW", "MATERIALIZED VIEW", "FOREIGN TABLE"});

src/main/mondrian/rolap/aggmatcher/JdbcSchema.java
String[] tableTypes = { "TABLE", "VIEW", "MATERIALIZED VIEW" , "FOREIGN TABLE"};

Thanks!

[jazzido]

+1

[buggtb]

Someone pointed me to this commit. We run a fork currently, and I go thtem to test the change and it seems to work fine. So the next Saiku release due tomorrow (probably) will include the updated mondrian.