Fix pg_dumpall so that when --clean is specified, it drops roles and
authorTom Lane <tgl@sss.pgh.pa.us>
Sat, 11 Apr 2009 20:23:05 +0000 (20:23 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Sat, 11 Apr 2009 20:23:05 +0000 (20:23 +0000)
commitd487b3df34ecdecc35a977688980b66a08abcd01
tree57797a2efc44af959b6c4984c37365a3f3026c02
parent00ee03ec8357ab4b56f0fe55d6addfa73bfd93a3
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.
src/bin/pg_dump/pg_dumpall.c