Fwd: PostgreSQL Statement Dependency Resolving | Schema Upgrade

---------- Forwarded message ---------
From: Jagmohan Kaintura <jagmohan(at)tecorelabs(dot)com>
Date: Mon, Feb 22, 2021 at 7:44 AM
Subject: PostgreSQL Statement Dependency Resolving | Schema Upgrade
To: <pgsql-admin(at)postgresql(dot)org>

Hi Team,

WHile performing a schema upgrade which needs any alter in the definition
of schema object, it always asks to execute that statement with CASCADE as
it has many dependent objects on it.

Most of the time we have to drop a lot of entities to just compile a simple
view.

In out case :
Views are being referenced by many other schema objects , in procedures,
functions and views.

Do we have any PostgreSQL extension or any standardized method which can
help with capturing all the cascade objects before dropping them and then
reloading once the new definition is applied.

--
*Best Regards,*
Jagmohan
Senior Consultant, TecoreLabs.

--
*Best Regards,*
Jagmohan
Senior Consultant, TecoreLabs.