On Friday 16 November 2007 2:48 pm, Scott Marlowe wrote: > On Nov 16, 2007 3:43 PM, Ed L. <pgsql@xxxxxxxxxxxxx> wrote: > > That looks about as ugly as can be. Ugh. What it appears > > to boil down to is that views become unusable unless you are > > willing to invest the effort in a complex build system. The > > DB should handle this issue automatically. Does Oracle? > > Really? I find a build system to be a pretty necessary part > of enterprise development. I can't imagine trying to keep > track of what I've done to my db without using some kind of > simple .sql scripts with all my ddl in them. > > And I use views and user defined functions a lot. The overall schema upgrade management system is not the difficult part. I find the difficulty comes with, for example, 5 levels of view dependencies. The view you want to update requires you to rebuild 15 others, which in turn requires you to trace back another 15 views, and so on until you reach the leafs of the tree. You don't know those dependencies when you create the first few views. Maybe you just manually discover all these dependency paths each time you decide to change a view with dependencies. That's the part I'm griping about and for which I was hoping for a better way. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
