Peter Eisentraut <peter_e@gmx.net> wrote:
I'll need more time to ponder your other points, but...
> You don't need a new command or key word for this. How about
> ALTER MATERIALIZED VIEW DISCARD?
I don't like this because we don't have ALTER TABLE REINDEX. But
the fact that DISCARD is a keyword does open up some interesting
syntax possibilities without adding more keywords. Maybe:
DISCARD MATERIALIZED VIEW DATA tm;
Or something like that. Paint buckets are over there by the
bikeshed. Have at it. :-)
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company