On Thu, May 12, 2016 at 1:05 AM, hari.prasath <hari.prasath@zohocorp.com> wrote:
> However if the same methods in matview.c
> OpenMatViewIncrementalMaintenance & CloseMatViewIncrementalMaintenance are
> mad extern its possible to do DML from the patches like i am building now.
>
> Is there any other way of doing DML operations on materialized views
> from patch.?
If you want to maintain materialized data using application-level
DML, you should use a table, not a materialized view. Once there
is built-in incremental maintenance, allowing DML will just make
the contents of a materialized view completely unreliable.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company