Kevin Grittner <kgrittn@ymail.com> writes:
> Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Peter claimed upthread that REFRESH is a subcommand of ALTER
>> MATERIALIZE VIEW
> It's not, nor do I think it should be.
Oh, never mind then.
>> and that this operation should be another one.� That sounds
>> pretty reasonable from here.
> That feels completely wrong to me.� For one thing, I can't think of
> any ALTER commands to populate or remove data.� What did you think
> of the idea of something like DISCARD MATERIALIZED VIEW DATA as a
> new statment?� Or maybe RESET MATERIALIZED VIEW?
I could live with either DISCARD or RESET.
regards, tom lane