Re: pg_dump needs SELECT privileges on irrelevant extension table

From: Jacob Champion <jchampion(at)timescale(dot)com>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>, Akshat Jaimini <destrex271(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: pg_dump needs SELECT privileges on irrelevant extension table
Date: 2023-07-14 22:20:39
Message-ID: CAAWbhmjsm+bJrwC1eTGpGk+6MQFG_1vA2g1+Fqa0xE78v1Xncg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Thanks for the reviews, both of you!

On Fri, Jul 14, 2023 at 5:04 AM Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:
> Seems reasonable at first glance. Isn't it going to save some work anyway later on, so the performance hit could end up negative?

Theoretically it could, if the OID list sent during getPolicies()
shrinks enough. I tried a quick test against the regression database,
but it's too noisy on my machine to know whether the difference is
really meaningful.

--Jacob

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alexander Lakhin 2023-07-15 07:00:00 Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm()
Previous Message Daniel Gustafsson 2023-07-14 13:07:08 Re: pg_basebackup: errors on macOS on directories with ".DS_Store" files

Browse pgsql-hackers by date

  From Date Subject
Next Message David G. Johnston 2023-07-14 22:22:34 Re: CommandStatus from insert returning when using a portal.
Previous Message Chapman Flack 2023-07-14 22:12:32 Re: CommandStatus from insert returning when using a portal.