pgsql: Recurse to sequences on ownership change for all relkinds

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема pgsql: Recurse to sequences on ownership change for all relkinds
Дата
Msg-id E1g5Evx-0007dN-LA@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Recurse to sequences on ownership change for all relkinds

When a table ownership is changed, we must apply that also to any owned
sequences.  (Otherwise, it would result in a situation that cannot be
restored, because linked sequences must have the same owner as the
table.)  But this was previously only applied to regular tables and
materialized views.  But it should also apply to at least foreign
tables.  This patch removes the relkind check altogether, because it
doesn't save very much and just introduces the possibility of similar
omissions.

Bug: #15238
Reported-by: Christoph Berg <christoph.berg@credativ.de>

Branch
------
REL_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/6485469606c15ae219977b1c228a266087eb30ca

Modified Files
--------------
src/backend/commands/tablecmds.c | 16 ++++++----------
1 file changed, 6 insertions(+), 10 deletions(-)


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: pgsql: Incorporate strerror_r() into src/port/snprintf.c, too.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pgsql: Incorporate strerror_r() into src/port/snprintf.c, too.