IVM is not supported to contain a view( or materialized view).
We need to contsider in the case of updating base table included in materlialized view, when mview is included in IVM.
Currently, An error is returned when execute CREATE INCREMENTAL MATERIALIZED VIEW.
test=# CREATE TABLE base (id int,name text);
CREATE TABLE
test=# CREATE VIEW
test=# CREATE VIEW t_view AS SELECT FROM base;
CREATE VIEW
test=# CREATE INCREMENTAL MATERIALIZED VIEW t_mv_ivm AS SELECT FROM t_view;
ERROR: VIEW or MATERIALIZED VIEW is not supported with IVM
IVM is not supported to contain a view( or materialized view).
We need to contsider in the case of updating base table included in materlialized view, when mview is included in IVM.
Currently, An error is returned when execute CREATE INCREMENTAL MATERIALIZED VIEW.
test=# CREATE TABLE base (id int,name text); CREATE TABLE test=# CREATE VIEW test=# CREATE VIEW t_view AS SELECT FROM base; CREATE VIEW test=# CREATE INCREMENTAL MATERIALIZED VIEW t_mv_ivm AS SELECT FROM t_view; ERROR: VIEW or MATERIALIZED VIEW is not supported with IVM