Skip to content

PostgreSQL: Support REFRESH MATERIALIZED VIEW - #2769

Open
LucaCappelletti94 wants to merge 3 commits into
mainfrom
upstream/refresh-materialized-view
Open

LucaCappelletti94 wants to merge 3 commits into
mainfrom
upstream/refresh-materialized-view

Conversation

@LucaCappelletti94

Copy link
Copy Markdown
Contributor

REFRESH MATERIALIZED VIEW m and REFRESH MATERIALIZED VIEW CONCURRENTLY app.m WITH NO DATA failed under every dialect with Expected: an SQL statement, found: REFRESH

This adds Statement::RefreshMaterializedView, holding the view name, whether CONCURRENTLY was written and the optional WITH [NO] DATA. The name is visited as a relation. The statement parses in every dialect, as VACUUM and RESET do. WITH [NO] DATA is an Option<bool> because the existing WithData also carries Teradata's AND [NO] STATISTICS, which REFRESH does not take.

docs: https://www.postgresql.org/docs/current/sql-refreshmaterializedview.html

@codecov-commenter

codecov-commenter commented Oct 29, 2026 •

Copy link
Copy Markdown

Codecov Report

❌ Patch coverage is 90.62500% with 3 lines in your changes missing coverage. Please review.
✅ Project coverage is 82.53%. Comparing base (b22bf61) to head (6cec5da).

Files with missing lines Patch % Lines
src/ast/mod.rs 80.00% 0 Missing and 3 partials ⚠️
Additional details and impacted files
@@           Coverage Diff           @@
##             main    #2769   +/-   ##
=======================================
  Coverage   82.52%   82.53%           
=======================================
  Files          42       42           
  Lines       35533    35565   +32     
  Branches    35533    35565   +32     
=======================================
+ Hits        29323    29352   +29     
  Misses       2675     2675           
- Partials     3535     3538    +3     

☔ View full report in Codecov by Harness.
📢 Have feedback on the report? Share it here.

🚀 New features to boost your workflow:
  • ❄️ Test Analytics: Detect flaky tests, report on failures, and find test suite problems.

@LucaCappelletti94
LucaCappelletti94 force-pushed the upstream/refresh-materialized-view branch from 84a5ea7 to 6cec5da Compare October 29, 2026 18:17
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants