On Thu, May 12, 2016 at 1:05 AM, hari.prasath <hari.pras...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers