pgsql: Remove the DELETEs from pg_shadow and pg_group that pg_dumpall - Mailing list pgsql-committers

From tgl@svr1.postgresql.org (Tom Lane)
Subject pgsql: Remove the DELETEs from pg_shadow and pg_group that pg_dumpall
Date
Msg-id 20051010222949.8FA89D9EF1@svr1.postgresql.org
Whole thread Raw
List pgsql-committers
Log Message:
-----------
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.

Modified Files:
--------------
    pgsql/doc/src/sgml/ref:
        pg_dumpall.sgml (r1.52 -> r1.53)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/pg_dumpall.sgml.diff?r1=1.52&r2=1.53)
    pgsql/src/bin/pg_dump:
        pg_dumpall.c (r1.67 -> r1.68)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dumpall.c.diff?r1=1.67&r2=1.68)

pgsql-committers by date:

Previous
From: tgl@svr1.postgresql.org (Tom Lane)
Date:
Subject: pgsql: Use a safer order of operations in dropdb(): rollbackable
Next
From: uniware@pgfoundry.org (User Uniware)
Date:
Subject: vcproject - vcproject: New Directory