Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a materialized view in Postgres 9.3 that I'd like to update with new columns. Other materialized views also depend upon this view, but the error message indicates that dropping a view isn't possible when other objects depend on it. It also appears from the documentation that the REPLACE keyword isn't valid for a materialized view. Is there any shortcut aside from dropping all dependent objects and rebuilding each one?

ERROR: cannot drop materialized view latest_charges because other objects depend on it

share|improve this question
Sadly, I think you're stuck with dropping them all and rebuilding. –  Craig Ringer Jan 7 '14 at 22:58
@CraigRinger interested in adding this as an answer? –  dezso Sep 1 '14 at 12:54

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.