Thread

Commits

Fix pg_dump for GRANT OPTION among initial privileges.
- c6ff165f99a7 11.11 landed
- b933c9c0ba87 10.16 landed
- ad2b7c9bb061 9.6.21 landed
- a0d31b1c9414 12.6 landed
- b8daf894f0d3 13.2 landed
- f713ff7c646e 14.0 landed

pg_dump vs. GRANT OPTION among initial privileges

Noah Misch <noah@leadboat.com> — 2021-01-09T10:24:23Z

pg_dump can generate invalid SQL syntax if an aclitem in pg_init_privs
contains a GRANT OPTION (an asterisk in the aclitemout() representation).
Also, pg_dump uses REVOKE GRANT OPTION FOR where it needs plain REVOKE.  For
more details, see the log message in the attached patch.  I recommend
reviewing "diff -w" output first.  I'm not certain the test suite will always
find those REVOKE statements in the same order; if that order varies, one
regex will need more help.