> 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers