pg_dump: don't require SELECT permission for undumped extension table

Edit
ID 4255
Title pg_dump: don't require SELECT permission for undumped extension table
Topic Bug Fixes
Created 2023-03-27 16:10:58
Last modified 2023-11-13 22:05:04 (11 months ago)
Latest email 2023-11-15 19:59:25 (10 months, 4 weeks ago)
Status
2023-11: Committed
2023-09: Moved to next CF
2023-07: Moved to next CF
Target version stable
Authors Jacob Champion (jchampion)
Reviewers Akshat Jaimini (akshatj)Become reviewer
Committer Tom Lane (tgl)
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run:
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/4255
git checkout commitfest/cf/4255
Emails
pg_dump needs SELECT privileges on irrelevant extension table
First at 2023-03-20 16:44:24 by Jacob Champion <jchampion at timescale.com>
Latest at 2023-11-15 19:59:25 by Jacob Champion <champion.p at gmail.com>
Latest attachment (v4-0001-dont-try-to-dump-extension-RLS-policies.patch) at 2023-10-17 21:11:16 from Tom Lane <tgl at sss.pgh.pa.us>
    Attachment (v4-0001-dont-try-to-dump-extension-RLS-policies.patch) at 2023-10-17 21:11:16 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (since-v2.diff.txt) at 2023-08-09 23:10:39 from Jacob Champion <jchampion at timescale.com> (Patch: No)
    Attachment (v2-0001-Add-failing-test-for-undumped-extension-table.patch) at 2023-06-29 16:24:32 from Jacob Champion <jchampion at timescale.com> (Patch: Yes)
    Attachment (dump-perf-200k.sql) at 2023-03-20 22:51:28 from Jacob Champion <jchampion at timescale.com> (Patch: No)
    Attachment (0001-pg_dump-skip-lock-for-extension-tables-without-polic.patch) at 2023-03-20 16:44:24 from Jacob Champion <jchampion at timescale.com> (Patch: Yes)
History
When Who What
2023-11-13 22:05:04 Tom Lane (tgl) Closed in commitfest 2023-11 with status: Committed
2023-11-09 19:38:31 Tom Lane (tgl) Added tgl as committer
2023-10-01 12:37:54 Peter Eisentraut (petere) Closed in commitfest 2023-09 with status: Moved to next CF
2023-08-01 07:50:15 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2023-07 with status: Moved to next CF
2023-07-14 07:45:53 Akshat Jaimini (akshatj) Posted review with messageid <168932075333.24788.17422212196008953618.pgcf@coridan.postgresql.org>
2023-07-14 07:40:06 Akshat Jaimini (akshatj) New status: Ready for Committer
2023-07-12 18:10:45 Akshat Jaimini (akshatj) Added akshatj as reviewer
2023-03-27 16:11:15 Jacob Champion (jchampion) Changed authors to Jacob Champion (jchampion)
2023-03-27 16:11:15 Jacob Champion (jchampion) Changed targetversion to stable
2023-03-27 16:10:58 Jacob Champion (jchampion) Attached mail thread 00d46a48-3324-d9a0-49bf-e7f0f11d1038@timescale.com
2023-03-27 16:10:58 Jacob Champion (jchampion) Created patch record
Edit