Ian Harding <harding.ian@xxxxxxxxx> writes: > Brand X doesn't do it in their backend either. If your Brand X is the same as my Brand X then it's worth noting that they didn't previously do anything sane in their backend. It used to invalidate all your views and you had to recompile them before they would work again. I wonder whether it would be saleable to have an option to work around this "feature". I'm thinking one of two directions: 1) An alternate type of view that just stores the text of the view and is interpreted at time of use like: CREATE DYNAMIC VIEW foo AS (SELECT * FROM tab) or 2) A command to recompile a view which would go back to the original source and reinterpret it like: ALTER VIEW foo RECOMPILE Or I guess you could have the latter and then add the former as a view that automatically recompiles any time a object it depends on is altered. -- greg ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
