I have a table with many dependancies such as: functions, views and materialised views. I'd like to update a column from an int to a bigint.
The issue I have is that doing so requires dropping a large number of dependancies in order and then re-building them in order.
Is it possible to turn the dependancy ladder off while I alter the column, update the required views/functions then re-enable it all.
This is coming from an Oracle background where it's perfectly fine to have temporarily invalid dependancies which makes migrations over various DB's environments a breeze.
In Postgresql I'm finding the process is very orchestrated and time consuming to engineer, whereas in Oracle I can just update all the columns & dependancies irrespective of order.