pgsql: Fix pg_dumpall so that when --clean is specified, it drops roles - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Fix pg_dumpall so that when --clean is specified, it drops roles
Date
Msg-id 20090411202305.D64237540FB@cvs.postgresql.org
Whole thread Raw
List pgsql-committers
Log Message:
-----------
Fix pg_dumpall so that when --clean is specified, it drops roles and
tablespaces in an order that has some chance of working.
Per a complaint from Kevin Bailey.

This is a pre-existing bug, but given the lack of prior complaints I'm
not sure it's worth back-patching.  In most cases failure of the DROP
commands wouldn't be that important anyway.

In passing, fix syntax errors in dumpCreateDB()'s queries for old servers;
these were apparently introduced in recent binary_upgrade patch.

Modified Files:
--------------
    pgsql/src/bin/pg_dump:
        pg_dumpall.c (r1.123 -> r1.124)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dumpall.c?r1=1.123&r2=1.124)

pgsql-committers by date:

Previous
From: alvherre@postgresql.org (Alvaro Herrera)
Date:
Subject: pgsql: Make string more alike other similar messages.
Next
From: gsmet@pgfoundry.org (User Gsmet)
Date:
Subject: pgfouine - pgfouine: implemented a simple garbage collector mechanism