Обсуждение: pgsql: Fix lookup error in extended stats ownership check

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

pgsql: Fix lookup error in extended stats ownership check

От
Tomas Vondra
Дата:
Fix lookup error in extended stats ownership check

When an ownership check on extended statistics object failed, the code
was calling aclcheck_error_type to report the failure, which is clearly
wrong, resulting in cache lookup errors. Fix by calling aclcheck_error.

This issue exists since the introduction of extended statistics, so
backpatch all the way back to PostgreSQL 10. It went unnoticed because
there were no tests triggering the error, so add one.

Reported-by: Mark Dilger
Backpatch-through: 10, where extended stats were introduced
Discussion: https://postgr.es/m/1F238937-7CC2-4703-A1B1-6DC225B8978A%40enterprisedb.com

Branch
------
REL_14_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/a371a5ba349d9c39e7754f7d0f195ac46ee87b3f

Modified Files
--------------
src/backend/catalog/objectaddress.c     |  3 ++-
src/test/regress/expected/stats_ext.out | 11 +++++++++++
src/test/regress/sql/stats_ext.sql      |  9 +++++++++
3 files changed, 22 insertions(+), 1 deletion(-)