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_19_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/0ae4e866a92daec609db0752b5e07bc844215ae3
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