Jim C. Nasby wrote: > > 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. > > I agree that CREATE DYNAMIC would be a good thing to have. It would > certainly save me time on some of my projects. > > Can we TODO this?
How is this different from materialized views, which is already on the TODO list? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
