pgsql: pg_dump: label INDEX ATTACH ArchiveEntries with an owner.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: pg_dump: label INDEX ATTACH ArchiveEntries with an owner.
Дата
Msg-id E1kzOYH-00072M-UN@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
pg_dump: label INDEX ATTACH ArchiveEntries with an owner.

Although a partitioned index's attachment to its parent doesn't
have separate ownership, the ArchiveEntry for it needs to be
marked with an owner anyway, to ensure that the ALTER command
is run by the appropriate role when restoring with
--use-set-session-authorization.  Without this, the ALTER will
be run by the role that started the restore session, which will
usually work but it's formally the wrong thing.

Back-patch to v11 where this type of ArchiveEntry was added.
In HEAD, add equivalent commentary to the just-added TABLE ATTACH
case, which I'd made do the right thing already.

Discussion: https://postgr.es/m/1094034.1610418498@sss.pgh.pa.us

Branch
------
REL_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/9f15188a1b822fafa59ca2b022a876fde0a175b8

Modified Files
--------------
src/bin/pg_dump/pg_dump.c | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Doc: fix description of privileges needed for ALTER PUBLICATION.
Следующее
От: Alvaro Herrera
Дата:
Сообщение: pgsql: Invent struct ReindexIndexInfo