On Fri, Jul 16, 2021 at 2:43 PM Markhof, Ingolf
<ingolf.markhof@de.verizon.com> wrote:
> I wonder how you deal with it in a professional way. Sounds like some type of "make" (that UNIX tool dealing with
dependenciesin the context of e.g. programming in C) would be helpful...
>
I see this question coming out very often, and quite frankly I'm not
able to fully understand it.
I think you will have your view (and more in general, object)
definitions into some kind of source control management, so adding or
removing columns from the table could be easily reproduced into the
view.
If you don't have the view source code (that is what often I'm argued
with), you can always use pg_get_viewdef() to get the source code
(adding some more machinery to get all the details).
At least you don't find your application running into errors because a
view (or a trigger) has not compiled (and that happened to me in
Oracle).
And my vote goes to sqitch for deployment and change management
<http://sqitch.org/> (and guess what? it works with Oracle too).
Luca
