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 (10 months ago)

Latest email

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

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