agora inbox for pgsql-committers@postgresql.orghelp / color / mirror / Atom feed
pgsql: Fix error message for concurrent repack on materialized views 2+ messages / 1 participants [nested] [flat]
* pgsql: Fix error message for concurrent repack on materialized views @ 2026-09-09 10:58 Álvaro Herrera <alvherre@kurilemu.de> 0 siblings, 0 replies; 2+ messages in thread From: Álvaro Herrera @ 2026-09-09 10:58 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Fix error message for concurrent repack on materialized views Previously, running REPACK (CONCURRENTLY) on a materialized view failed with a confusing "has no identity index" error. REPACK (CONCURRENTLY) replays changes decoded from WAL, but a materialized view produces none, since it cannot be modified by DML and REFRESH rewrites it through a transient heap that is not logically decoded. Fix this by reporting a clear error for materialized views upfront, alongside the existing checks for system catalogs and TOAST tables, and document the limitation. Author: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com> Reviewed-by: Kiran Kaki <itskkpg@gmail.com> Backpatch-through: 19 Discussion: https://postgr.es/m/CALj2ACXPvy4_LkQ0nHKgbZjAGK9fkDqRYUvXA3hgwxPm_X7Eng@mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/412ef97d925c54d6135afb4c22cceccb6421d8a2 Modified Files -------------- contrib/test_decoding/expected/repack.out | 6 ++++++ contrib/test_decoding/sql/repack.sql | 5 +++++ doc/src/sgml/ref/repack.sgml | 6 ++++++ src/backend/commands/repack.c | 8 ++++++++ 4 files changed, 25 insertions(+) ^ permalink raw reply [nested|flat] 2+ messages in thread
* pgsql: Fix error message for concurrent repack on materialized views @ 2026-09-09 10:58 Álvaro Herrera <alvherre@kurilemu.de> 0 siblings, 0 replies; 2+ messages in thread From: Álvaro Herrera @ 2026-09-09 10:58 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Fix error message for concurrent repack on materialized views Previously, running REPACK (CONCURRENTLY) on a materialized view failed with a confusing "has no identity index" error. REPACK (CONCURRENTLY) replays changes decoded from WAL, but a materialized view produces none, since it cannot be modified by DML and REFRESH rewrites it through a transient heap that is not logically decoded. Fix this by reporting a clear error for materialized views upfront, alongside the existing checks for system catalogs and TOAST tables, and document the limitation. Author: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com> Reviewed-by: Kiran Kaki <itskkpg@gmail.com> Backpatch-through: 19 Discussion: https://postgr.es/m/CALj2ACXPvy4_LkQ0nHKgbZjAGK9fkDqRYUvXA3hgwxPm_X7Eng@mail.gmail.com Branch ------ REL_19_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/40d811540a589cbddeb0736966f2541088134163 Modified Files -------------- contrib/test_decoding/expected/repack.out | 6 ++++++ contrib/test_decoding/sql/repack.sql | 5 +++++ doc/src/sgml/ref/repack.sgml | 6 ++++++ src/backend/commands/repack.c | 8 ++++++++ 4 files changed, 25 insertions(+) ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2026-09-09 10:58 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2026-09-09 10:58 pgsql: Fix error message for concurrent repack on materialized views Álvaro Herrera <alvherre@kurilemu.de> 2026-09-09 10:58 pgsql: Fix error message for concurrent repack on materialized views Álvaro Herrera <alvherre@kurilemu.de>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox