Re: ALTER INDEX .. RENAME allows to rename tables/views as well

Поиск
Список
Период
Сортировка
От Bossart, Nathan
Тема Re: ALTER INDEX .. RENAME allows to rename tables/views as well
Дата
Msg-id 2735A836-1DE2-4448-93B8-7B558A7F016E@amazon.com
обсуждение исходный текст
Ответ на Re: ALTER INDEX .. RENAME allows to rename tables/views as well  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-hackers
On 10/18/21, 4:56 PM, "Alvaro Herrera" <alvherre@alvh.no-ip.org> wrote:
> Now, what is the worst that can happen if we rename a table under SUE
> and somebody else is using the table concurrently?  Is there any way to
> cause a backend crash or something like that?  As far as I can see,
> because we grab a fresh catalog snapshot for each query, you can't cause
> anything worse than reading from a different table.  I do lack
> imagination for creating attacks, though.

This message [0] in the thread for lowering the lock level for
renaming indexes seems to indicate that there may be some risk of
crashing.

Nathan

[0] https://postgr.es/m/CA%2BTgmobtmFT5g-0dA%3DvEFFtogjRAuDHcYPw%2BqEdou5dZPnF%3Dpg%40mail.gmail.com


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

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: XTS cipher mode for cluster file encryption
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: can we add subscription TAP test option "vcregress subscriptioncheck" for MSVC builds?