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.