3 ms·
Like automatically refreshing materialized views, by which I mean when a base table is changed, the engine uses the definition of the materialized view to run t
by kccqzy 7y ago
Like automatically refreshing materialized views, by which I mean when a base table is changed, the engine uses the definition of the materialized view to run triggers to update materialized view.
- Twisell 7y agoThis is related to default implementation details, this behavior can be achieved using trigger/materialized view on PostgreSQL as well.
- kccqzy 7y agoMy entire point is that I shouldn't have to write the triggers myself. PostgreSQL figures out the triggers from my definition of the materialized view.