Re: Skip ExecCheckRTPerms in CTAS with no data

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.