On 2013-02-21 14:11:10 -0800, Kevin Grittner wrote: > Tom Lane <t...@sss.pgh.pa.us> wrote: > > Kevin Grittner <kgri...@ymail.com> writes: > > >> 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. > > I figured this was worth a pass through the keyword list to look > for all imperative verbs suitable for this, which could support the > needed syntax without adding a new keyword. Here are the > possibilities I came up with, along with a note about why they are > keywords already. > > DISABLE MATERIALIZED VIEW mv; -- ALTER clause for constraints > DISCARD MATERIALIZED VIEW DATA mv; -- session state > RELEASE MATERIALIZED VIEW DATA mv; -- savepoint > RESET MATERIALIZED VIEW DATA mv; -- run-time parameter > > I think any of these could work. I'm personally most inclined > toward DISABLE MATERIALIZED VIEW. It seems to convey the semantics > better, especially if you leave out DATA as an additonal word.
> Given that a materialized view will retain its query, tablespace, > indexes, statistics targets, etc. with this operation, and will > just not be available for scanning, some of the above seem > downright misleading without DATA thrown in. I vote for RESET or DISCARD. DISABLE sounds more like you disable automatic refreshes or somesuch. Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers