On Thu, Feb 28, 2013 at 11:00 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: >> Well, personally, I'm in favor of either TRUNCATE or ALTER >> MATERIALIZED VIEW ... DISCARD. I think it's a dangerous precedent to >> suppose that we're going to start using DISCARD for things that have >> nothing to do with the existing meanings of DISCARD. > > Yeah, there's actually a serious problem with choosing DISCARD: > surely we are not going to include "trash all MVs" in the behavior > of DISCARD ALL. So unless you would like to say that DISCARD ALL > doesn't mean what it appears to mean, we can't make MV reset be > one of the sub-flavors of DISCARD.
Good point. > So that seems to leave us with either TRUNCATE or an ALTER sub-syntax. > Personally I'd prefer the latter but it's surely debatable. I agree. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
