Re: view management

Thanks, Justin.

On Friday 16 November 2007 4:38 pm, Justin Pasher wrote:
> We have a system that has quite a few views to access some of
> the data (although we purposely tried to avoid views that
> pulled from other view due to some performance issues), but
> when we had all of the view interdependencies, we had a simple
> shell script that ran through a list of SQL files and imported
> them one after the other. If we every had to drop a view that
> cascaded to other dependent views, we would just do the DROP
> VIEW ... CASCADE, then run the shell script to recreate all of
> the views. In your situation, the time consuming part would be
> the initial creation of the script to get the SQL files in the
> correct order. After that is done, it's just a matter of
> proper maintenance to keep it working.