On 2/19/13 5:47 PM, Kevin Grittner wrote:
> When I went to do this, I hit a shift/reduce conflict, because with
> TABLE being optional it couldn't tell whether:
>
> TRUNCATE MATERIALIZED VIEW x, y, z;
>
> ... was looking for five relations or three. That goes away with
> MATERIALIZED escalated to TYPE_FUNC_NAME_KEYWORD. Is that OK?
Is TRUNCATE even the right command here? For regular tables TRUNCATE is
a fast DELETE, which logically empties the table. For materialized
views, there is no deleting, so this command (I suppose?) just
invalidates the materalized view. That's not the same thing.
Are there TRUNCATE triggers on materialized views?