Log Message: ----------- Add a role property 'rolinherit' which, when false, denotes that the role doesn't automatically inherit the privileges of roles it is a member of; for such a role, membership in another role can be exploited only by doing explicit SET ROLE. The default inherit setting is TRUE, so by default the behavior doesn't change, but creating a user with NOINHERIT gives closer adherence to our current reading of SQL99. Documentation still lacking, and I think the information schema needs another look.
Modified Files:
--------------
pgsql/doc/src/sgml:
catalogs.sgml (r2.108 -> r2.109)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/catalogs.sgml.diff?r1=2.108&r2=2.109)
func.sgml (r1.271 -> r1.272)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml.diff?r1=1.271&r2=1.272)
pgsql/src/backend/catalog:
aclchk.c (r1.115 -> r1.116)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/aclchk.c.diff?r1=1.115&r2=1.116)
system_views.sql (r1.16 -> r1.17)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/system_views.sql.diff?r1=1.16&r2=1.17)
pgsql/src/backend/commands:
user.c (r1.157 -> r1.158)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/user.c.diff?r1=1.157&r2=1.158)
pgsql/src/backend/nodes:
copyfuncs.c (r1.311 -> r1.312)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/nodes/copyfuncs.c.diff?r1=1.311&r2=1.312)
equalfuncs.c (r1.248 -> r1.249)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/nodes/equalfuncs.c.diff?r1=1.248&r2=1.249)
pgsql/src/backend/parser:
gram.y (r2.502 -> r2.503)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/gram.y.diff?r1=2.502&r2=2.503)
keywords.c (r1.162 -> r1.163)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/keywords.c.diff?r1=1.162&r2=1.163)
pgsql/src/backend/utils/adt:
acl.c (r1.121 -> r1.122)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/acl.c.diff?r1=1.121&r2=1.122)
pgsql/src/include/catalog:
catversion.h (r1.291 -> r1.292)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h.diff?r1=1.291&r2=1.292)
pg_authid.h (r1.1 -> r1.2)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_authid.h.diff?r1=1.1&r2=1.2)
pgsql/src/include/nodes:
parsenodes.h (r1.285 -> r1.286)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/parsenodes.h.diff?r1=1.285&r2=1.286)
pgsql/src/include/utils:
acl.h (r1.82 -> r1.83)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/acl.h.diff?r1=1.82&r2=1.83)
pgsql/src/test/regress/expected:
rules.out (r1.104 -> r1.105)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/rules.out.diff?r1=1.104&r2=1.105)
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
