> I've thought for some time that, given that it can't reproduce the MV
> states exactly, pg_dump shouldn't even try. I think it would be more
> useful to have two operating modes selectable by command line switch:
> refresh all matviews, or refresh none of them.
This seems like a reasonable solution. Also, I think "refresh none"
should be the default.
BTW, this does mean that "REFRESH ALL MATERIALIZED VIEWS" should be a
future feature ...
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com