pg_dump vs. GRANT OPTION among initial privileges - Mailing list pgsql-hackers

From Noah Misch
Subject pg_dump vs. GRANT OPTION among initial privileges
Date
Msg-id 20210109102423.GA160022@rfd.leadboat.com
Whole thread Raw
List pgsql-hackers
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.

Attachment

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: [HACKERS] logical decoding of two-phase transactions
Next
From: Simon Riggs
Date:
Subject: Re: WIP: System Versioned Temporal Table