On 2013-02-21 04:14:09 +0000, Greg Stark wrote: > On Wed, Feb 20, 2013 at 9:25 PM, Peter Eisentraut <pete...@gmx.net> wrote: > > More generally, I would consider the invalidation of a materialized view > > a DDL command, whereas truncating a table is a DML command. > > That's not entirely true. From the database's point of view, TRUNCATE > is in many ways actually DDL. > > I actually don't really dislike using "TRUNCATE" for this command. I > was more asking about whether this meant people were thinking of the > view as a thing where you could control the data in it by hand and > could have the view be "empty" rather than just "not valid".
It also might get confusing when we get materialized views that are auto-updateable. I am not suggesting to forward TRUNCATE to the internal storage in that case but giving an error so its an easy to find distinction to a normal table seems like a good idea. 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