On Wed, Dec 14, 2022 at 07:05:34PM +0100, Alvaro Herrera wrote: > On 2022-Dec-14, Nathan Bossart wrote: >> On Wed, Dec 14, 2022 at 12:07:13PM +0300, Pavel Luzanov wrote: >> > I found that granting MAINTAIN privilege does not allow the TOAST table to >> > be vacuumed. >> >> Hm. My first thought is that this is the appropriate behavior. WDYT? > > It seems wrong to me. If you can vacuum a table, surely you can also > vacuum its toast table. If you can vacuum all normal tables, you should > be able to vacuum all toast tables too.
Okay. Should all the privileges governed by MAINTAIN apply to a relation's TOAST table as well? I would think so, but I don't want to assume too much before writing the patch. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com
