On 2020-11-20 06:37, Michael Paquier wrote:
But if you consider materialized views as a variant of normal views,
then the INSERT privilege would be applicable if you pass an INSERT on
the materialized view through to the underlying tables, like for a view.
INSERT to materialized views is not supported, but perhaps you mean
having a variant of auto updatable for matviews? I am not sure how to
clearly define that.
Not currently, but it could be a future feature. Basically an insert
would be passed on to the underlying tables (using INSTEAD triggers),
and then a refresh would be triggered automatically.
