Re: vacuumdb: permission denied for schema "pg_temp_7" - Mailing list pgsql-bugs

From vaibhave postgres
Subject Re: vacuumdb: permission denied for schema "pg_temp_7"
Date
Msg-id CAM_eQjyWnu_LUt6JWjh3boNFHAT9DBrcbamhG3Xy39Q4Ph=2rg@mail.gmail.com
Whole thread Raw
In response to Re: vacuumdb: permission denied for schema "pg_temp_7"  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: vacuumdb: permission denied for schema "pg_temp_7"
List pgsql-bugs
Thanks for the review and feedback. 

On Sat, Sep 21, 2024 at 11:33 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Fujii Masao <masao.fujii@oss.nttdata.com> writes:
> It looks like reindexdb has the same issue. It would be good to
> update reindexdb to skip temp tables as well to fix this.

Agreed.

> For the proposed patch, it seems better to use CppAsString2(RELPERSISTENCE_TEMP)
> instead of 't'.

+1, if we can easily avoid hard-coding that value we should do so.
It's not that we're going to change the value; it's that it makes
it way easier to grep the source tree for relevant code.

                        regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: vacuumdb: permission denied for schema "pg_temp_7"
Next
From:
Date:
Subject: AW: BUG #18615: installer cannot be executed as "nt-autorität\system"