| From: | surya poondla <suryapoondla4(at)gmail(dot)com> |
|---|---|
| To: | Rafia Sabih <rafia(dot)pghackers(at)gmail(dot)com> |
| Cc: | Giuliano Gagliardi <gogi(at)gogi(dot)tv>, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Two issues with REFRESH MATERIALIZED VIEW CONCURRENTLY |
| Date: | 2026-03-02 22:45:32 |
| Message-ID: | CAOVWO5p2U8rMvh3pJ4WaNN7ES4SbiEKXLV_0pZ-UdYp0kACa7g@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Hi All,
Thank you Rafia for the suggestions.
I split both the bugs in 2 different commits, attaching the patches here.
For bug1, I added the test case for NULL values too.
For bug 2, I only changed matview.c and added no test case as the timings
are not constant.
I ran the regression tests for both the patches and all tests succeeded in
both cases.
Regards,
Surya Poondla
>
| Attachment | Content-Type | Size |
|---|---|---|
| 0003-Fix-REFRESH-MATERIALIZED-VIEW-CONCURRENTLY-to-detect_bug1.patch | application/octet-stream | 6.7 KB |
| 0003-Fix-REFRESH-MATERIALIZED-VIEW-CONCURRENTLY-performance_bug2.patch | application/octet-stream | 5.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Guo | 2026-03-03 01:03:49 | Re: BUG #19418: SQL/JSON JSON_VALUE() does not conform to ISO/IEC 9075-2:2023(E) 6.34 <JSON value constructor> |
| Previous Message | Nathan Bossart | 2026-03-02 19:15:51 | Re: basic_archive lost archive_directory |