Replace a materialized view in Postgres
As of PostgreSQL 9.4: Different to the documentation of CREATE VIEW, the documentation of CREATE MATERIALIZED VIEW does NOT mention the REPLACE keyword. There seems to be no shortcut aside from dropping all dependent objects and rebuilding each one.

When you do so, I can only recommend two small things:


Use DROP MATERIALIZED VIEW blabla CASCADE to get a list of all dependent objects
Do the drop and recreation of all dependent object in one transaction.