Обсуждение: 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
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/5be8ce82e84f8f3604916c06668990c524f3856d

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(-)