6 ms·
Read the whole textbook, MATERIALIZED VIEW requires a REFRESH that is outside the transaction that made the change: https://www.postgresql.org/docs/current/rule
by amirouche 4y ago
Read the whole textbook, MATERIALIZED VIEW requires a REFRESH that is outside the transaction that made the change: https://www.postgresql.org/docs/current/rules-materializedviews.html https://www.postgresql.org/docs/current/rules-materializedvi...
- apavlo 4y agoPostgres is not every system. Just because it requires manually refreshing matviews doesn't mean that every DBMS works that way. Seriously, read a textbook: http://db.cs.duke.edu/papers/fntdb12-ChirkovaYang-mat_views.pdf http://db.cs.duke.edu/papers/fntdb12-ChirkovaYang-mat_views....