On Fri, 2021-07-16 at 14:42 +0200, Markhof, Ingolf wrote: > In Oracle, I can easily delete a table or view that is used by existing views. > The system marks the affected views. I can then re-define the deleted table or > view and have all dependent views easily re-compiled. Done. ... or you end up with "invalid views" which give you an error when used. Sorry, but we don't like inconsistent data, however convenient they might be. > PostgreSQL instead is preventing inconsistency. It simply refuses to delete a > view or table that is referenced by other views. Consequently, I need to > delete all dependent views first, re-define the one I want to change and > then create all dependent views deleted before... - Which is much more difficult > to handle. > > I wonder how you deal with it in a professional way. Sounds like some type of > "make" (that UNIX tool dealing with dependencies in the context of e.g. > programming in C) would be helpful... You have your view definitions stored in a source control system, and/or you employ a version management tool like Liquibase. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
