Re: Materialized views WIP patch

On Tue, Nov 27, 2012 at 10:58 AM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
> I unlike using keywords DO for this purpose - when we use it for
> anonymous blocks

Yeah, I don't much like that either. My original suggestion when
Kevin and I discussed this over voice was ALTER MATERIALIZED VIEW ..
REFRESH or ALTER MATERIALIZED VIEW .. UPDATE. I don't particularly
like syntaxes involving DO or LOAD because those words already have
strong associations with completely unrelated features. Now, if we
don't want to do that and we don't want to use ALTER for a
data-modifying command either, another option would be to invent a new
toplevel command:

REFRESH <view_name>;

Of course, that does introduce another keyword, but the penalty for a
new unreserved keyword is pretty small. It seems like a rough
analogue of CLUSTER, which could be spelled ALTER TABLE <table_name>
UPDATE TABLE ORDER TO if keyword minimization trumped both concision
and clarity, but it doesn't.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company