| From: | Jagmohan Kaintura <jagmohan(at)tecorelabs(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | PostgreSQL Statement Dependency Resolving | Schema Upgrade |
| Date: | 2021-02-22 02:14:08 |
| Message-ID: | CA+cYFtvfT-ct3U9nVbFsSh2V=4TskBR7AswXQGXBxSu+Cqeh_A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Carlos Armijo Severino | 2021-02-22 18:58:33 | Help me, Please |
| Previous Message | Victor Sudakov | 2021-02-20 14:34:20 | Re: index bloat estimation |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron | 2021-02-22 02:38:20 | Re: Script checking to see what database it's connected to |
| Previous Message | Julien Rouhaud | 2021-02-22 01:19:37 | Re: Script checking to see what database it's connected to |