pgsql: CREATE INDEX: use the original userid for more ACL checks.

Поиск
Список
Период
Сортировка
От Noah Misch
Тема pgsql: CREATE INDEX: use the original userid for more ACL checks.
Дата
Msg-id E1o58MY-001lnC-9V@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
CREATE INDEX: use the original userid for more ACL checks.

Commit a117cebd638dd02e5c2e791c25e43745f233111b used the original userid
for ACL checks located directly in DefineIndex(), but it still adopted
the table owner userid for more ACL checks than intended.  That broke
dump/reload of indexes that refer to an operator class, collation, or
exclusion operator in a schema other than "public" or "pg_catalog".
Back-patch to v10 (all supported versions), like the earlier commit.

Nathan Bossart and Noah Misch

Discussion: https://postgr.es/m/f8a4105f076544c180a87ef0c4822352@stmuk.bayern.de

Branch
------
REL_14_STABLE

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

Modified Files
--------------
contrib/citext/Makefile                      |  2 +-
contrib/citext/expected/create_index_acl.out | 78 ++++++++++++++++++++++
contrib/citext/sql/create_index_acl.sql      | 79 +++++++++++++++++++++++
src/backend/commands/indexcmds.c             | 96 +++++++++++++++++++++++-----
4 files changed, 239 insertions(+), 16 deletions(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: pgsql: Remove unportable test
Следующее
От: Noah Misch
Дата:
Сообщение: pgsql: Fix PostgreSQL::Test aliasing for Perl v5.10.1.