Dimitri Fontaine <dimitri@2ndQuadrant.fr> writes:
> Under that light, using ALTER is strange indeed.
Agreed, seems like a poor choice.
> I still don't like
> using LOAD that much, allow me to try a last syntax proposal. Well all I
> can find just now would be:
> UPDATE MATERIALIZED VIEW mv FOR EACH ROW;
> UPDATE MATERIALIZED VIEW mv FOR EACH STATEMENT [ CONCURRENTLY ];
> The only value of such a proposal is that it's not LOAD and it's still
> not introducing any new keyword. Oh it's also avoiding to overload the
> SNAPSHOT keyword. Well, it still does not look like the best candidate.
I think this syntax would require making MATERIALIZED (and possibly also
VIEW) fully reserved keywords, which would be better avoided.
regards, tom lane