Re: [SQL] maintaining nested views

2009-10-12 Thread Tom Lane
Maximilian Tyrtania writes: > Quite often i find myself reluctant to nest views, because of the > maintenance issues this usually involves. As you know, you can't easily > alter the "lower level" views, because the higher level ones depend on them. > So, to add a field to a lower level view one ha

[SQL] maintaining nested views

2009-10-11 Thread Maximilian Tyrtania
Quite often i find myself reluctant to nest views, because of the maintenance issues this usually involves. As you know, you can't easily alter the "lower level" views, because the higher level ones depend on them. So, to add a field to a lower level view one has to: drop view vw_lowlevel CASCADE;