Add OR REPLACE option to CREATE MATERIALIZED VIEW

Edit
ID 5099
Title Add OR REPLACE option to CREATE MATERIALIZED VIEW
CI (CFBot) Summary
Stats (from CFBot) Patch version: v8, Patch count: 1, First patch: +813−27, All patches: +813−27
Tags SQL Commands
Created 2024-07-02 08:38:53
Last modified 2026-08-01 00:00:09 (16 hours ago)
Latest email 2026-07-23 07:05: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
PG19-Final (2026-03-01 – 2026-04-09): Moved to different CF
PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF
PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF
PG19-2 (2025-09-01 – 2025-09-30): Moved to different CF
2025-03 (2025-03-01 – 2025-04-08): Moved to different CF
2025-01 (2025-01-01 – 2025-01-31): Moved to different CF
2024-11 (2024-11-01 – 2024-11-30): Moved to different CF
2024-09 (2024-09-01 – 2024-09-30): Moved to different CF
Target version
Authors Erik Wienhold (ewie)
Reviewers Paul Jungwirth (pjungwir), newtglobal postgresql_contributors (newtpostgrescontributors), Soumya S Murali (soumyamurali) Become reviewer
Committer
Links
Emails
CREATE OR REPLACE MATERIALIZED VIEW
First at 2024-07-02 01:22:00 by Erik Wienhold <ewie at ewie.name>
Latest at 2026-07-23 07:05:48 by Rafia Sabih <rafia.pghackers at gmail.com>
Latest attachment (v8-0001-Add-OR-REPLACE-option-to-CREATE-MATERIALIZED-VIEW.patch) at 2026-06-28 18:14:11 from Erik Wienhold <ewie at ewie.name>
    Attachment (v8-0001-Add-OR-REPLACE-option-to-CREATE-MATERIALIZED-VIEW.patch) at 2026-06-28 18:14:11 from Erik Wienhold <ewie at ewie.name> (Patch: Yes)
    Attachment (v7-0001-Add-OR-REPLACE-option-to-CREATE-MATERIALIZED-VIEW.patch) at 2025-08-05 01:17:06 from Erik Wienhold <ewie at ewie.name> (Patch: Yes)
    Attachment (v6-0001-Add-CREATE-OR-REPLACE-MATERIALIZED-VIEW.patch) at 2025-03-10 02:46:05 from Erik Wienhold <ewie at ewie.name> (Patch: Yes)
    Attachment (v5-0001-Add-CREATE-OR-REPLACE-MATERIALIZED-VIEW.patch) at 2025-01-12 21:33:05 from Erik Wienhold <ewie at ewie.name> (Patch: Yes)
    Attachment (v4-0001-Add-CREATE-OR-REPLACE-MATERIALIZED-VIEW.patch) at 2024-10-31 00:22:17 from Erik Wienhold <ewie at ewie.name> (Patch: Yes)
    Attachment (v3-0001-Add-CREATE-OR-REPLACE-MATERIALIZED-VIEW.patch) at 2024-09-05 20:33:51 from Erik Wienhold <ewie at ewie.name> (Patch: Yes)
    Attachment (v2-0001-Add-CREATE-OR-REPLACE-MATERIALIZED-VIEW.patch) at 2024-07-27 00:45:15 from Erik Wienhold <ewie at ewie.name> (Patch: Yes)
    Attachment (v1-0001-Add-CREATE-OR-REPLACE-MATERIALIZED-VIEW.patch) at 2024-07-02 01:22:00 from Erik Wienhold <ewie at ewie.name> (Patch: Yes)
History
When Who What
2026-08-01 00:00:09 CFbot Moved from CF PG20-1 to CF PG20-2
2026-04-10 04:30:09 Soumya S Murali (soumyamurali) Added soumyamurali as reviewer
2026-04-01 14:36:10 Erik Wienhold (ewie) Changed targetversion to None
2026-04-01 14:35:56 Erik Wienhold (ewie) Moved from CF PG19-Final to CF PG20-1
2026-02-01 01:50:07 Erik Wienhold (ewie) Moved from CF PG19-4 to CF PG19-Final
2026-01-12 23:46:25 Paul Jungwirth (pjungwir) Added pjungwir as reviewer
2025-12-07 21:32:08 Erik Wienhold (ewie) Moved from CF PG19-3 to CF PG19-4
2025-10-11 01:31:17 Erik Wienhold (ewie) Moved from CF PG19-2 to CF PG19-3
2025-08-05 02:00:19 Erik Wienhold (ewie) Changed name to Add OR REPLACE option to CREATE MATERIALIZED VIEW
2025-08-05 01:18:13 Erik Wienhold (ewie) New status: Needs review
2025-07-03 16:57:26 Erik Wienhold (ewie) Changed targetversion to 19
2025-07-03 16:31:15 Erik Wienhold (ewie) New status: Waiting on Author
2025-07-03 16:30:07 Erik Wienhold (ewie) Moved from CF 2025-03 to CF PG19-2
2025-03-05 05:18:25 newtglobal postgresql_contributors (newtpostgrescontributors) Added newtpostgrescontributors as reviewer
2025-02-26 16:00:13 Erik Wienhold (ewie) Closed in commitfest 2025-01 with status: Moved to next CF
2024-12-05 08:45:09 Kirill Reshke (reshke) Closed in commitfest 2024-11 with status: Moved to next CF
2024-10-07 12:16:20 Erik Wienhold (ewie) Closed in commitfest 2024-09 with status: Moved to next CF
2024-07-02 08:39:13 Erik Wienhold (ewie) Changed authors to Erik Wienhold (ewie)
2024-07-02 08:39:13 Erik Wienhold (ewie) Changed targetversion to 18
2024-07-02 08:38:54 Erik Wienhold (ewie) Attached mail thread 3c86a16f-4272-4df3-9959-70a9a7d88a71@ewie.name
2024-07-02 08:38:54 Erik Wienhold (ewie) Created patch record
Edit