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. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
