[fdo-internals] FDO Postgis provider and materialized views

[Gabriele Monfardini]

Hi all,

we're using FDO Postgis provider in Mapguide open source.
In particular FDO 3.8.
It seems that materialized views are not (yet) supported.

We can workaround the problem creating a regular view that selects all data
from the materialized views but then FDO is unable to find a primary key
and in general to retrieve information about constraints.

Unfortunately AFAIK materialized views are not exposed through
information_schema since they are not exactly part of SQL standard.

They may be found selecting data from pg_class where relkind='m'.
This obviously is postgresql specific.

Is there any plan to support materialized views in PostGIS FDO?

Best regards,

Gabriele Monfardini

-----
Gabriele Monfardini
LdP Progetti GIS
tel: 0577.531049
email: monfardini at ldpgis.it
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/fdo-internals/attachments/20160630/5b0b7e58/attachment.html>