From c6b9924bec6f621f9bbceb38d7839a83c148c6ce Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Mon, 10 Oct 2005 22:29:48 +0000 Subject: Remove the DELETEs from pg_shadow and pg_group that pg_dumpall used to emit when given the --clean option, in favor of individual DROP ROLE commands. The old technique could not possibly work in 8.1, and was never a very good idea anyway IMHO. The DROP ROLE approach has the defect that the DROPs will fail for roles that own objects or have privileges, but perhaps we can improve that later. --- doc/src/sgml/ref/pg_dumpall.sgml | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/pg_dumpall.sgml b/doc/src/sgml/ref/pg_dumpall.sgml index 4cee1a4ed72..a89bf89164d 100644 --- a/doc/src/sgml/ref/pg_dumpall.sgml +++ b/doc/src/sgml/ref/pg_dumpall.sgml @@ -1,5 +1,5 @@ @@ -90,8 +90,9 @@ PostgreSQL documentation - Include SQL commands to clean (drop) the databases before - recreating them. + Include SQL commands to clean (drop) databases before + recreating them. DROP commands for roles and + tablespaces are added as well. -- cgit v1.2.3