Materialized view

Classic Servoy
1

Hi all,

I’m using servoy 7.4.5.
I’ve installed postgres 9.4.5 to use a MATERIALIZED VIEW.
The problem is that servoy seems to doesn’t recognize this kind of VIEW.

I can do any kind of query by “getDatasetByQuery” method on these views but I can’t base any form on them
or any other kind of operations.

Am I missing to do something?

P.s. The same problem on servoy 8.0.2

Thanks in advance

2

Hi Marco,

I remember discussing this with Rob Ganzevles of Servoy.
To be able to link a form to a database object Servoy wants to know of it’s existence. For this it reads the Catalog or Information Schema.
In the PostgreSQL catalog however a Materialized view is marked as type ‘m’, Tables are marked as ‘r’ and Views as ‘v’. Servoy only fetches the ‘r’ and ‘v’ types which does show Materialized Views with other vendors, but not PostgreSQL (for the reason explained).
So it’s not you, it’s Servoy.

I suggest you file a feature request in Servoy’s support tracker.

(I believe in JDBC the types are t and v, but I could be mistaken)

3

Thank you Robert,
I’ll open the feature request.

Regards