Skip to content

Support to IVM including view or mview #33

@thoshiai

Description

@thoshiai

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions