pgsql: Fix ordering of GRANT commands in pg_dumpall for database creati

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix ordering of GRANT commands in pg_dumpall for database creati
Date: 2019-05-22 05:57:04
Message-ID: E1hTKFM-00068O-W3@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix ordering of GRANT commands in pg_dumpall for database creation

This uses a method similar to 68a7c24f, which guarantees that GRANT
commands using the WITH GRANT OPTION are dumped in a way so as cascading
dependencies are respected. As databases do not have support for
initial privileges via pg_init_privs, we need to repeat again the same
ACL reordering method.

ACL for databases have been moved from pg_dumpall to pg_dump in v11, so
this impacts pg_dump for v11 and above, and pg_dumpall for v9.6 and
v10.

Discussion: https://postgr.es/m/15788-4e18847520ebcc75@postgresql.org
Author: Nathan Bossart
Reviewed-by: Haribabu Kommi
Backpatch-through: 9.6

Branch
------
REL9_6_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/a21fb12e7cc3e5ef976a384e7e7295d7e9b7460d

Modified Files
--------------
src/bin/pg_dump/pg_dumpall.c | 33 ++++++++++++++++++++++++++-------
1 file changed, 26 insertions(+), 7 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Meskes 2019-05-22 10:06:36 Re: pgsql: Implement PREPARE AS statement for ECPG.
Previous Message Tom Lane 2019-05-22 03:51:22 pgsql: Un-break pg_upgrade regression test.