Re: vacuumdb: permission denied for schema "pg_temp_7"

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>
Cc: Christophe Pettus <xof(at)thebuild(dot)com>, Nathan Bossart <nathandbossart(at)gmail(dot)com>, vaibhave postgres <postgresvaibhave(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Noah Misch <noah(at)leadboat(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org, vsekar(at)microsoft(dot)com
Subject: Re: vacuumdb: permission denied for schema "pg_temp_7"
Date: 2024-09-27 00:48:56
Message-ID: ZvYA-Hv9TRpfLhEK@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, Sep 26, 2024 at 11:19:33PM +0900, Fujii Masao wrote:
> Should reindexdb skip temporary tables or indexes even when specified explicitly
> with the -t or -i options? Currently, the patch doesn't change this behavior;
> reindexdb will still not skip them if specified.
>
> If we agree to back-patch, it should be applied to v13, as parallel mode was
> introduced in that version.

Looks sensible to me to apply that to the database and schema queries.
Thanks for the patch.
--
Michael

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2024-09-27 03:15:29 BUG #18635: " $libdir/adminpack could not be loaded" error with pg_upgrade to PostgreSQL17
Previous Message Michael Paquier 2024-09-27 00:45:12 Re: BUG #18630: Incorrect memory access inside ReindexIsProcessingIndex() on VACUUM