Re: pg_dump needs SELECT privileges on irrelevant extension table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jacob Champion <champion(dot)p(at)gmail(dot)com>
Cc: Stephen Frost <sfrost(at)snowman(dot)net>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Akshat Jaimini <destrex271(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Aleksander Alekseev <aleksander(at)timescale(dot)com>
Subject: Re: pg_dump needs SELECT privileges on irrelevant extension table
Date: 2023-11-09 19:02:51
Message-ID: 1154732.1699556571@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

I wrote:
> Jacob Champion <champion(dot)p(at)gmail(dot)com> writes:
>> Is this approach backportable?

> The code fix would surely work in the back branches. Whether the
> behavioral change is too big to be acceptable in minor releases
> is something I don't have a strong opinion on.

I'm hearing nothing but crickets :-(

If nobody objects by say Monday, I'm going to go ahead and
commit (and backpatch) the patch I posted at [1].

regards, tom lane

[1] https://www.postgresql.org/message-id/2984517.1697577076%40sss.pgh.pa.us

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tomas Vondra 2023-11-09 19:14:46 Re: Logical replication is missing block of rows when sending initial sync?
Previous Message Alexander Korotkov 2023-11-09 12:25:59 Re: BUG #18187: Unexpected error: "variable not found in subplan target lists" triggered by JOIN

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2023-11-09 19:19:12 Re: Fix output of zero privileges in psql
Previous Message Laurenz Albe 2023-11-09 18:55:09 Re: Bug: RLS policy FOR SELECT is used to check new rows