summaryrefslogtreecommitdiff
path: root/src/test/regress/sql/matview.sql
AgeCommit message (Expand)Author
2025-11-24Improve detection of implicitly-temporary views.Tom Lane
2024-12-11Add missing BUFFERS OFF in regression tests, take 2David Rowley
2024-03-05Fix search_path to a safe value during maintenance operations.Jeff Davis
2024-02-05Fix assertion if index is dropped during REFRESH CONCURRENTLYHeikki Linnakangas
2023-03-13Remove incidental md5() function uses from main regression testsPeter Eisentraut
2021-08-07Really fix the ambiguity in REFRESH MATERIALIZED VIEW CONCURRENTLY.Tom Lane
2020-12-30Sanitize IF NOT EXISTS in EXPLAIN for CTAS and matviewsMichael Paquier
2020-11-21Remove INSERT privilege check at table creation of CTAS and matviewMichael Paquier
2020-11-16Relax INSERT privilege requirement for CTAS and matviews WITH NO DATAMichael Paquier
2017-05-03Remove useless and rather expensive stanza in matview regression test.Tom Lane
2017-02-06Fix typos in comments.Heikki Linnakangas
2017-01-25Change unknown-type literals to type text in SELECT and RETURNING lists.Tom Lane
2016-10-10Make regression tests less dependent on hash table order.Andres Freund
2016-08-11Fix busted Assert for CREATE MATVIEW ... WITH NO DATA.Tom Lane
2016-06-27Fix CREATE MATVIEW/CREATE TABLE AS ... WITH NO DATA to not plan the query.Tom Lane
2016-04-15Use less-generic names in matview.sql.Tom Lane
2014-12-13Add CINE option for CREATE TABLE AS and CREATE MATERIALIZED VIEWAndrew Dunstan
2014-08-26Fix superuser concurrent refresh of matview owned by another.Kevin Grittner
2014-03-06Don't reject ROW_MARK_REFERENCE rowmarks for materialized views.Tom Lane
2013-12-11Add table name to VACUUM statement in matview.c.Kevin Grittner
2013-11-04Fix breakage of MV column name list usage.Kevin Grittner
2013-11-02Fix subquery reference to non-populated MV in CMV.Kevin Grittner
2013-10-09Add record_image_ops opclass for matview concurrent refresh.Kevin Grittner
2013-08-02Fix crash in error report of invalid tuple lockAlvaro Herrera
2013-07-16Add support for REFRESH MATERIALIZED VIEW CONCURRENTLY.Kevin Grittner
2013-05-06Move materialized views' is-populated status into their pg_class entries.Tom Lane
2013-05-06Disallow unlogged materialized views.Tom Lane
2013-05-02Prevent (auto)vacuum from truncating first page of populated matview.Kevin Grittner
2013-05-01Fix permission tests for views/tables proven empty by constraint exclusion.Tom Lane
2013-04-30Add regression test for bug fixed by recent refactoring.Kevin Grittner
2013-03-19Use ORDER BY on matview definitions were needed for stable plans.Kevin Grittner
2013-03-14Add regression test for MV join to view.Kevin Grittner
2013-03-04Add a materialized view relations.Kevin Grittner