Fix the wrong behavior of REFRESH MATERIALIZED VIEW CONCURRENTLY

6579

Title

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-10-02 03:00:10 (1 month ago)

Latest email

2026-07-31 07:44:48 (3 months ago)

Status

PG20-3 (2026-11-01 – 2026-11-30): Needs review

PG20-2 (2026-09-01 – 2026-09-30): Moved to different CF

PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF

Target version

Authors

Rafia Sabih (rafia.sabih), Surya Poondla (spoondla)

Reviewers

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-10-02 03:00:10	shihao zhong (zhong950419)	Moved from CF PG20-2 to CF PG20-3
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