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-08-09 23:10:39
Message-ID: CAAWbhmi+fu6Aiucjf76Ss2GPEijrz6VLriby1LaG=p9zNTOxZg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Hi all,

v3 fixes a doc comment I forgot to fill in; there are no other code
changes. To try to further reduce the activation energy, I've also
attached an attempt at a backport to 11. The main difference is the
absence of catalogIdHash, which showed up in 15, so we don't get the
benefit of that deduplication.

Thanks,
--Jacob

Attachment Content-Type Size
since-v2.diff.txt text/plain 461 bytes
v3-0001-Add-failing-test-for-undumped-extension-table.patch text/x-patch 3.5 KB
v3-0002-pg_dump-skip-lock-for-extension-tables-without-po.patch text/x-patch 6.7 KB
backport-11-0001.patch.txt text/plain 4.5 KB
backport-11-0002.patch.txt text/plain 8.4 KB

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2023-08-10 02:39:17 Re: BUG #18034: Accept the spelling "+infinity" in datetime input is not accurate
Previous Message Tom Lane 2023-08-09 15:26:12 Re: BUG #18051: char(N) and varchar(N) behave opposite to the documentation

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2023-08-09 23:45:43 Re: Support to define custom wait events for extensions
Previous Message Bruce Momjian 2023-08-09 22:03:15 Re: PG 16 draft release notes ready