The real challenge in a gbase database schema change isn't writing the DDL — it's uncovering every object that depends on the table before you hit “execute.” Many production incidents are caused not by syntax errors, but by overlooked views, triggers, or functions that silently break. This article uses PG_DEPEND, PG_REWRITE, PG_TRIGGER, and other system catalogs to build a structured pre‑change inspection routine.
Classifying Risk by Change Type
DDL Type
Key Risk
Recommended Approach














