pgsql: Fix pg_dump for GRANT OPTION among initial privileges.
От | Noah Misch |
---|---|
Тема | pgsql: Fix pg_dump for GRANT OPTION among initial privileges. |
Дата | |
Msg-id | E1l0s5U-0002N1-0j@gemulon.postgresql.org обсуждение исходный текст |
Список | pgsql-committers |
Fix pg_dump for GRANT OPTION among initial privileges. The context is an object that no longer bears some aclitem that it bore initially. (A user issued REVOKE or GRANT statements upon the object.) pg_dump is forming SQL to reproduce the object ACL. Since initdb creates no ACL bearing GRANT OPTION, reaching this bug requires an extension where the creation script establishes such an ACL. No PGXN extension does that. If an installation did reach the bug, pg_dump would have omitted a semicolon, causing a REVOKE and the next SQL statement to fail. Separately, since the affected code exists to eliminate an entire aclitem, it wants plain REVOKE, not REVOKE GRANT OPTION FOR. Back-patch to 9.6, where commit 23f34fa4ba358671adab16773e79c17c92cbc870 first appeared. Discussion: https://postgr.es/m/20210109102423.GA160022@rfd.leadboat.com Branch ------ REL9_6_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/ad2b7c9bb061e85d1afe0debb916e00ca8cf8d5b Modified Files -------------- src/bin/pg_dump/dumputils.c | 65 ++++++++-------------- src/test/modules/test_pg_dump/t/001_base.pl | 51 +++++++++++++++++ .../modules/test_pg_dump/test_pg_dump--1.0.sql | 9 +++ 3 files changed, 84 insertions(+), 41 deletions(-)
В списке pgsql-committers по дате отправления: