Forum OpenACS Q&A: Response to retrieving complex queries

Collapse
Posted by Roberto Mello on
In the aD Clickstream module, they used materialized views, which PG
doesn't support. But I faked them by creating tables with the _mv suffix.

A table kept track of all the _mv's (and their definition). A function
would drop and recreate the MV's one by one, being called by a
scheduled proc on AOLserver. This same approach would probably work
for you too.