pgsql: reindexdb: Escape index names in parallel catalog query

Поиск
Список
Период
Сортировка
Искать

pgsql: reindexdb: Escape index names in parallel catalog query

От:
Noah Misch <noah@leadboat.com>
Дата:
reindexdb: Escape index names in parallel catalog query

get_parallel_tabidx_list() builds an array of regclass values, and
incorrectly assigned quotes to the query built, leading to incorrect
queries once the names of the objects included single quotes.

This issue is by embedding each object name inside their own
appendQualifiedRelation() before being attached to the final catalog
query.  Some tests are added.

Issue introduced by 47f99a407de2.

Reported-by: Anthropic OSS program
Author: Anthropic OSS program
Reviewed-by: Álvaro Herrera 
Reviewed-by: Michael Paquier 
Security: CVE-2026-116325
Backpatch-through: 17

Branch
------
REL_18_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/aac5e6f5038a4d3b9a6d71b30e57fd9c9436033c
Author: Michael Paquier 

Modified Files
--------------
src/bin/scripts/common.c           |  5 +++++
src/bin/scripts/reindexdb.c        | 21 +++++++++++++++++----
src/bin/scripts/t/090_reindexdb.pl | 17 +++++++++++++++++
3 files changed, 39 insertions(+), 4 deletions(-)

FAQ