Fix the wrong behavior of REFRESH MATERIALIZED VIEW CONCURRENTLY

Edit
ID 6579
Title Fix the wrong behavior of REFRESH MATERIALIZED VIEW CONCURRENTLY
CI (CFBot) Summary
Stats (from CFBot) Patch version: v7, Patch count: 2, First patch: +137−40, All patches: +246−43
Tags Bugfix
Created 2026-03-12 00:39:08
Last modified 2026-08-01 00:00:08 (1 week ago)
Latest email 2026-07-31 07:44:48 (1 week ago)
Status
PG20-2 (2026-09-01 – 2026-09-30): Needs review
PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF
Target version 19
Authors Rafia Sabih (rafia.sabih), Surya Poondla (spoondla)
Reviewers Become reviewer
Committer
Links
Emails
Two issues with REFRESH MATERIALIZED VIEW CONCURRENTLY
First at 2026-02-09 06:49:18 by Giuliano Gagliardi <gogi at gogi.tv>
Latest at 2026-07-31 07:44:48 by Yugo Nagata <nagata at sraoss.co.jp>
Latest attachment (v7-0001-Fix-REFRESH-MATERIALIZED-VIEW-CONCURRENTLY-to-det.patch) at 2026-07-16 09:19:09 from Rafia Sabih <rafia.pghackers at gmail.com>
    Attachment (v7-0001-Fix-REFRESH-MATERIALIZED-VIEW-CONCURRENTLY-to-det.patch) at 2026-07-16 09:19:09 from Rafia Sabih <rafia.pghackers at gmail.com> (Patch: No)
    Attachment (0006-Fix-REFRESH-MATERIALIZED-VIEW-CONCURRENTLY-to-detect.patch) at 2026-05-18 16:48:43 from surya poondla <suryapoondla4 at gmail.com> (Patch: No)
    Attachment (0005-Fix-REFRESH-MATERIALIZED-VIEW-CONCURRENTLY-to-detect_bug1.patch) at 2026-03-25 22:45:11 from surya poondla <suryapoondla4 at gmail.com> (Patch: No)
    Attachment (v4-0001-Fix-wrong-result-of-refresh-matview-concurrently.patch) at 2026-03-13 07:20:49 from cca5507 <cca5507 at qq.com> (Patch: Yes)
    Attachment (0003-Fix-REFRESH-MATERIALIZED-VIEW-CONCURRENTLY-to-detect_bug1.patch) at 2026-03-02 22:45:32 from surya poondla <suryapoondla4 at gmail.com> (Patch: Yes)
    Attachment (0002-Fix-REFRESH-MATERIALIZED-VIEW-CONCURRENTLY-NULL-hand.patch) at 2026-02-13 02:08:08 from surya poondla <suryapoondla4 at gmail.com> (Patch: Yes)
    Attachment (0001-Fix-REFRESH-MATERIALIZED-VIEW-CONCURRENTLY-to-detect.patch) at 2026-02-12 00:34:25 from surya poondla <suryapoondla4 at gmail.com> (Patch: Yes)
    Attachment (0001-Check-for-duplicate-rows-with-NULLs.patch) at 2026-02-11 19:48:04 from Rafia Sabih <rafia.pghackers at gmail.com> (Patch: Yes)
History
When Who What
2026-08-01 00:00:08 CFbot Moved from CF PG20-1 to CF PG20-2
2026-07-16 09:37:31 CFbot Patch does not need rebase anymore
2026-03-16 20:42:25 CFbot Patch needs rebase
2026-03-12 00:39:09 Surya Poondla (spoondla) Attached mail thread 40d694df-39fd-4a4a-9459-9d6489165f60@gogi.tv
2026-03-12 00:39:08 Surya Poondla (spoondla) Created patch record
Edit