[prev in list] [next in list] [prev in thread] [next in thread] 

List:       fdo-internals
Subject:    [fdo-internals] FDO Postgis provider and materialized views
From:       Gabriele Monfardini <monfardini () ldpgis ! it>
Date:       2016-06-30 17:23:58
Message-ID: CACw3ADiKXuSBuy6=v2yNYAsFLDgO3_mCZHDJt+E70mg3huyUOg () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


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@ldpgis.it

[Attachment #5 (text/html)]

<div dir="ltr">Hi all,<div><br></div><div>we&#39;re using FDO Postgis provider in \
Mapguide open source.</div><div>In particular FDO 3.8.</div><div>It seems that \
materialized views are not (yet) supported.</div><div><br></div><div>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.</div><div><br></div><div>Unfortunately AFAIK \
materialized views are not exposed through information_schema since they are not \
exactly part of SQL standard.</div><div><br></div><div>They may be found selecting \
data from pg_class where relkind=&#39;m&#39;.</div><div>This obviously is postgresql \
specific.<br></div><div><br></div><div>Is there any plan to support materialized \
views in PostGIS FDO?</div><div><br></div><div>Best \
regards,</div><div><br></div><div>Gabriele Monfardini</div><div><br \
clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div \
dir="ltr"><div>-----<br>Gabriele Monfardini<br>LdP Progetti GIS</div><div>tel: \
0577.531049<br>email: <a href="mailto:monfardini@ldpgis.it" \
target="_blank">monfardini@ldpgis.it</a></div></div></div></div> </div></div>


[Attachment #6 (text/plain)]

_______________________________________________
fdo-internals mailing list
fdo-internals@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-internals

[prev in list] [next in list] [prev in thread] [next in thread]