On 2/20/13 2:30 PM, Kevin Grittner wrote:
>> Are there TRUNCATE triggers on materialized views?
> No. Nor SELECT, INSERT, UPDATE, or DELETE triggers. You can't
> create a trigger of any type on a materialized view. I don't think
> that would interfere with event triggers, though.
More generally, I would consider the invalidation of a materialized view
a DDL command, whereas truncating a table is a DML command. This has
various implications with triggers, logging, permissions. I think it's
not good to mix those two.
Also note that un-invalidating==refreshing a materialized view is
already a DDL command.
