Re: pg_dump needs SELECT privileges on irrelevant extension table - Mailing list pgsql-hackers

From Jacob Champion
Subject Re: pg_dump needs SELECT privileges on irrelevant extension table
Date
Msg-id CAAWbhmjsm+bJrwC1eTGpGk+6MQFG_1vA2g1+Fqa0xE78v1Xncg@mail.gmail.com
Whole thread Raw
In response to Re: pg_dump needs SELECT privileges on irrelevant extension table  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: pg_dump needs SELECT privileges on irrelevant extension table
List pgsql-hackers
Thanks for the reviews, both of you!

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

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



pgsql-hackers by date:

Previous
From: Chapman Flack
Date:
Subject: Re: CommandStatus from insert returning when using a portal.
Next
From: "David G. Johnston"
Date:
Subject: Re: CommandStatus from insert returning when using a portal.