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

Title

Topic

Bug Fixes

Created

2023-03-27 16:10:58

Last modified

2023-11-13 22:05:04 (1 year ago)

Latest email

2023-11-15 19:59:25 (1 year 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

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