Skip to content

Support using materialized views #450

@levkk

Description

@levkk

Materialized views are recorded in a separate metadata table and not in information_schema.tables, so when one tries to use them in pgml.train(), they would get a "table not found" error.

A quick workaround is to create a regular view around the materialized view:

CREATE VIEW my_view AS SELECT * FROM my_mat_view;

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions