* Kevin Grittner (kgri...@ymail.com) wrote: > Peter Eisentraut <pete...@gmx.net> wrote: > > Is TRUNCATE even the right command here? For regular tables > > TRUNCATE is a fast DELETE, which logically empties the table. > > For materialized views, there is no deleting, so this command (I > > suppose?) just invalidates the materalized view. That's not the > > same thing. > > Hmm. That's what Greg Stark just said, and I replied that nobody > else had raised the issue in over three months. With Greg, that's > two now.
TRUNCATE MAT VIEW seems like the right command to me. Just my 2c.
Thanks,
Stephen
signature.asc
Description: Digital signature
