Add OR REPLACE option to CREATE MATERIALIZED VIEW

Log in to 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-14 21:01:23 (2 months ago)
Latest email 2026-08-21 13:13:12 (2 months ago)
Status
PG20-2 (2026-09-01 – 2026-09-30): Waiting on Author
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) Log in to 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-08-21 13:13:12 by Isaac Morland <isaac.morland at gmail.com>
Latest attachment (create-or-replace-matview-review.md) at 2026-08-05 19:17:26 from Paul A Jungwirth <pj at illuminatedcomputing.com>
    Attachment (create-or-replace-matview-review.md) at 2026-08-05 19:17:26 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: No)
    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-14 21:01:23 Paul Jungwirth (pjungwir) New status: Waiting on Author
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
Log in to edit