Materialized view

Questions and answers regarding general SQL and backend databases

Materialized view

Postby marco.rossi » Mon Jan 11, 2016 2:43 pm

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
Marco Rossi
Senior Analyst Developer
Freelance Consultant

IT Manager @Mantho
Webmaster @Sitoliquido
marco.rossi
 
Posts: 110
Joined: Sun Apr 12, 2015 9:33 pm

Re: Materialized view

Postby ROCLASI » Mon Jan 11, 2016 3:10 pm

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)
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: Materialized view

Postby marco.rossi » Fri Jan 15, 2016 3:52 pm

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

Regards
Marco Rossi
Senior Analyst Developer
Freelance Consultant

IT Manager @Mantho
Webmaster @Sitoliquido
marco.rossi
 
Posts: 110
Joined: Sun Apr 12, 2015 9:33 pm


Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 8 guests

cron