pgsql: Fix superuser concurrent refresh of matview owned by another.

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема pgsql: Fix superuser concurrent refresh of matview owned by another.
Дата
Msg-id E1XMIIz-0003Ss-9D@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Fix superuser concurrent refresh of matview owned by another.

Use SECURITY_LOCAL_USERID_CHANGE while building temporary tables;
only escalate to SECURITY_RESTRICTED_OPERATION while potentially
running user-supplied code.  The more secure mode was preventing
temp table creation.  Add regression tests to cover this problem.

This fixes Bug #11208 reported by Bruno Emanuel de Andrade Silva.

Backpatch to 9.4, where the bug was introduced.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/a9d0f1cff3fb10151be05be61d24ac9b680c170c

Modified Files
--------------
src/backend/commands/matview.c        |   93 ++++++++++++++++-----------------
src/test/regress/expected/matview.out |   12 +++++
src/test/regress/sql/matview.sql      |   13 +++++
3 files changed, 70 insertions(+), 48 deletions(-)


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: pgsql: pg_upgrade: prevent automatic oid assignment
Следующее
От: Kevin Grittner
Дата:
Сообщение: pgsql: Fix superuser concurrent refresh of matview owned by another.