On Fri, Mar 1, 2013 at 3:01 PM, Ants Aasma <ants@cybertec.at> wrote:
> . To give another example of potential future
> update semantics, if we were to allow users manually maintaining
> materialized view contents using DML commands, one would expect
> TRUNCATE to mean "make this matview empty", not "make this matview
> unavailable".
Wouldn't that just be a regular table then though? How is that a
materialized view?
If anything someone might expect truncate to delete any rows from the
source table that appear in the view. But I think it's likely that
even if materialized views were updateable truncate wouldn't be one of
the updateable operations.
--
greg