> I'm about 99% sure the answer to that is 'yes'. Are you thinking of
> having a background scheduler which handles the updating of
> schedule-driven (instead of trigger-driven) MVs..? Not to try to
> feature-creep this on you, but you might consider how a new backend
> process which handles scheduled tasks could be generalized to go beyond
> handling just MV updates.. :)
No feature-creeping; the two features described will be hard enough.
Besides, we have pg_agent for that.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com