pgsql: Arrange to remove pg_default_acl entries completely if their ACL

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Arrange to remove pg_default_acl entries completely if their ACL
Date: 2010-04-05 01:58:03
Message-ID: 20100405015803.A44777541D0@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Arrange to remove pg_default_acl entries completely if their ACL setting
is changed to match the hard-wired default. This avoids accumulating useless
catalog entries, and also provides a path for dropping the owning role without
using DROP OWNED BY. Per yesterday's complaint from Jaime Casanova, the
need to use DROP OWNED BY for that is less than obvious, so providing this
alternative method might save some user frustration.

Modified Files:
--------------
pgsql/doc/src/sgml/ref:
alter_default_privileges.sgml (r1.4 -> r1.5)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/alter_default_privileges.sgml?r1=1.4&r2=1.5)
pgsql/src/backend/catalog:
aclchk.c (r1.165 -> r1.166)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/aclchk.c?r1=1.165&r2=1.166)

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2010-04-05 02:12:51 Re: pgsql: Add contraint exclusion section to contraint docs.
Previous Message Tom Lane 2010-04-05 01:09:53 pgsql: Fix updateAclDependencies() to not assume that ACL role