pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Fix assertion if index is dropped during REFRESH CONCURRENTLY 6+ messages / 1 participants [nested] [flat]
* pgsql: Fix assertion if index is dropped during REFRESH CONCURRENTLY @ 2024-02-05 09:28 Heikki Linnakangas <heikki.linnakangas@iki.fi> 0 siblings, 0 replies; 6+ messages in thread From: Heikki Linnakangas @ 2024-02-05 09:28 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Fix assertion if index is dropped during REFRESH CONCURRENTLY When assertions are disabled, the built SQL statement is invalid and you get a "syntax error". So this isn't a serious problem, but let's avoid the assertion failure. Backpatch to all supported versions. Reviewed-by: Noah Misch Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/b96115acb8a0e08a46877c2b8ef2a7b5560b371b Modified Files -------------- src/backend/commands/matview.c | 7 +++++-- src/test/regress/expected/matview.out | 16 ++++++++++++++++ src/test/regress/sql/matview.sql | 17 +++++++++++++++++ 3 files changed, 38 insertions(+), 2 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Fix assertion if index is dropped during REFRESH CONCURRENTLY @ 2024-02-05 09:28 Heikki Linnakangas <heikki.linnakangas@iki.fi> 0 siblings, 0 replies; 6+ messages in thread From: Heikki Linnakangas @ 2024-02-05 09:28 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Fix assertion if index is dropped during REFRESH CONCURRENTLY When assertions are disabled, the built SQL statement is invalid and you get a "syntax error". So this isn't a serious problem, but let's avoid the assertion failure. Backpatch to all supported versions. Reviewed-by: Noah Misch Branch ------ REL_16_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/fb3836855ca12024f3d7432a4a04217073b1688c Modified Files -------------- src/backend/commands/matview.c | 7 +++++-- src/test/regress/expected/matview.out | 16 ++++++++++++++++ src/test/regress/sql/matview.sql | 17 +++++++++++++++++ 3 files changed, 38 insertions(+), 2 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Fix assertion if index is dropped during REFRESH CONCURRENTLY @ 2024-02-05 09:28 Heikki Linnakangas <heikki.linnakangas@iki.fi> 0 siblings, 0 replies; 6+ messages in thread From: Heikki Linnakangas @ 2024-02-05 09:28 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Fix assertion if index is dropped during REFRESH CONCURRENTLY When assertions are disabled, the built SQL statement is invalid and you get a "syntax error". So this isn't a serious problem, but let's avoid the assertion failure. Backpatch to all supported versions. Reviewed-by: Noah Misch Branch ------ REL_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/06f36bc01bf69f888896eb16025db8265b4df9be Modified Files -------------- src/backend/commands/matview.c | 7 +++++-- src/test/regress/expected/matview.out | 16 ++++++++++++++++ src/test/regress/sql/matview.sql | 17 +++++++++++++++++ 3 files changed, 38 insertions(+), 2 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Fix assertion if index is dropped during REFRESH CONCURRENTLY @ 2024-02-05 09:28 Heikki Linnakangas <heikki.linnakangas@iki.fi> 0 siblings, 0 replies; 6+ messages in thread From: Heikki Linnakangas @ 2024-02-05 09:28 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Fix assertion if index is dropped during REFRESH CONCURRENTLY When assertions are disabled, the built SQL statement is invalid and you get a "syntax error". So this isn't a serious problem, but let's avoid the assertion failure. Backpatch to all supported versions. Reviewed-by: Noah Misch Branch ------ REL_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/a45c950ae35e53de4007c9dd0991d5005a4bee7b Modified Files -------------- src/backend/commands/matview.c | 7 +++++-- src/test/regress/expected/matview.out | 16 ++++++++++++++++ src/test/regress/sql/matview.sql | 17 +++++++++++++++++ 3 files changed, 38 insertions(+), 2 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Fix assertion if index is dropped during REFRESH CONCURRENTLY @ 2024-02-05 09:28 Heikki Linnakangas <heikki.linnakangas@iki.fi> 0 siblings, 0 replies; 6+ messages in thread From: Heikki Linnakangas @ 2024-02-05 09:28 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Fix assertion if index is dropped during REFRESH CONCURRENTLY When assertions are disabled, the built SQL statement is invalid and you get a "syntax error". So this isn't a serious problem, but let's avoid the assertion failure. Backpatch to all supported versions. Reviewed-by: Noah Misch Branch ------ REL_13_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/b73d216489e1ee480b19d6ad31b784ea33c352f3 Modified Files -------------- src/backend/commands/matview.c | 7 +++++-- src/test/regress/expected/matview.out | 16 ++++++++++++++++ src/test/regress/sql/matview.sql | 17 +++++++++++++++++ 3 files changed, 38 insertions(+), 2 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Fix assertion if index is dropped during REFRESH CONCURRENTLY @ 2024-02-05 09:28 Heikki Linnakangas <heikki.linnakangas@iki.fi> 0 siblings, 0 replies; 6+ messages in thread From: Heikki Linnakangas @ 2024-02-05 09:28 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Fix assertion if index is dropped during REFRESH CONCURRENTLY When assertions are disabled, the built SQL statement is invalid and you get a "syntax error". So this isn't a serious problem, but let's avoid the assertion failure. Backpatch to all supported versions. Reviewed-by: Noah Misch Branch ------ REL_12_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/add8bc9b8c31fd0c7acfd64a4e2af71ea7b6b58c Modified Files -------------- src/backend/commands/matview.c | 7 +++++-- src/test/regress/expected/matview.out | 16 ++++++++++++++++ src/test/regress/sql/matview.sql | 17 +++++++++++++++++ 3 files changed, 38 insertions(+), 2 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2024-02-05 09:28 UTC | newest] Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-02-05 09:28 pgsql: Fix assertion if index is dropped during REFRESH CONCURRENTLY Heikki Linnakangas <heikki.linnakangas@iki.fi> 2024-02-05 09:28 pgsql: Fix assertion if index is dropped during REFRESH CONCURRENTLY Heikki Linnakangas <heikki.linnakangas@iki.fi> 2024-02-05 09:28 pgsql: Fix assertion if index is dropped during REFRESH CONCURRENTLY Heikki Linnakangas <heikki.linnakangas@iki.fi> 2024-02-05 09:28 pgsql: Fix assertion if index is dropped during REFRESH CONCURRENTLY Heikki Linnakangas <heikki.linnakangas@iki.fi> 2024-02-05 09:28 pgsql: Fix assertion if index is dropped during REFRESH CONCURRENTLY Heikki Linnakangas <heikki.linnakangas@iki.fi> 2024-02-05 09:28 pgsql: Fix assertion if index is dropped during REFRESH CONCURRENTLY Heikki Linnakangas <heikki.linnakangas@iki.fi>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox