Re: ALTER INDEX .. RENAME allows to rename tables/views as well - Mailing list pgsql-hackers

From Bossart, Nathan
Subject Re: ALTER INDEX .. RENAME allows to rename tables/views as well
Date
Msg-id 2735A836-1DE2-4448-93B8-7B558A7F016E@amazon.com
Whole thread Raw
In response to Re: ALTER INDEX .. RENAME allows to rename tables/views as well  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List 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 by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: XTS cipher mode for cluster file encryption
Next
From: Michael Paquier
Date:
Subject: Re: can we add subscription TAP test option "vcregress subscriptioncheck" for MSVC builds?