One way I have approached this problem is:
1) Use PgAdmin attempt the change.
2) Examine the error report PgAdmin displays that identifies which dependent views are preventing your progress.
3) Wrap your original DDL from step 1 within the DROP and CREATE DDL associated with the closest dependent view.
4) Return to step 1 and repeat until step 1 succeeds.
With multiple iterations of this procedure, you will incrementally grow a DDL script that drops dependent views in the correct order, eliminating dependencies, and then recreate them in the proper order, respecting dependencies.
When this procedure got old, I started using a script created using pg_dump and pg_restore, as initially outlined here:
and with a correction noted here:
-- B
From: "Elson Vaz" <elsonlei@xxxxxxxxx>
To: pgsql-general@xxxxxxxxxxxxxxxxxxxx
Sent: Tuesday, January 30, 2018 8:40:45 AM
Subject: Alter view with dependence without drop view!Hello!I want make change in one view that have dependence view's, so when i try to make change i'm block because of this, what is the best solution??thank you!!best regardElson Vaz
