Horton
Menu

Re: pg_dump needs SELECT privileges on irrelevant extension table

Jacob Champion <jchampion@timescale.com>

View thread
From: Jacob Champion <jchampion@timescale.com>
To: Andrew Dunstan <andrew@dunslane.net>, Akshat Jaimini <destrex271@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Tom Lane <tgl@sss.pgh.pa.us>
Date: 2023-07-14T22:20:39Z
Lists: pgsql-bugs, 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 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

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Don't try to dump RLS policies or security labels for extension objects.