Horton

Use a bitmask to represent role attributes

Alvaro Herrera <alvherre@alvh.no-ip.org>

View on postgr.es
Commit: 1826987a46d079458007b7b6bbcbbd852353adbb
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
Date: 2014-12-23T13:22:09Z
Releases: 9.5.0 
Use a bitmask to represent role attributes

The previous representation using a boolean column for each attribute
would not scale as well as we want to add further attributes.

Extra auxilliary functions are added to go along with this change, to
make up for the lost convenience of access of the old representation.

Catalog version bumped due to change in catalogs and the new functions.

Author: Adam Brightwell, minor tweaks by Álvaro
Reviewed by: Stephen Frost, Andres Freund, Álvaro Herrera

Files

PathChange+/−
doc/src/sgml/catalogs.sgml modified +86 −41
doc/src/sgml/func.sgml modified +127 −0
src/backend/access/transam/xlogfuncs.c modified +3 −2
src/backend/catalog/aclchk.c modified +70 −55
src/backend/catalog/Catalog.pm modified +1 −1
src/backend/catalog/genbki.pl modified +3 −0
src/backend/catalog/information_schema.sql modified +6 −1
src/backend/catalog/Makefile modified +1 −1
src/backend/catalog/objectaddress.c modified +1 −1
src/backend/catalog/system_views.sql modified +14 −14
src/backend/commands/dbcommands.c modified +3 −24
src/backend/commands/user.c modified +145 −99
src/backend/commands/variable.c modified +6 −2
src/backend/replication/logical/logicalfuncs.c modified +5 −11
src/backend/replication/slotfuncs.c modified +2 −1
src/backend/rewrite/rowsecurity.c modified +1 −1
src/backend/utils/adt/acl.c modified +182 −18
src/backend/utils/adt/ri_triggers.c modified +1 −1
src/backend/utils/init/miscinit.c modified +3 −20
src/backend/utils/init/postinit.c modified +1 −1
src/backend/utils/misc/superuser.c modified +3 −1
src/bin/pg_dump/pg_dumpall.c modified +10 −4
src/include/catalog/acldefs.h added +72 −0
src/include/catalog/catversion.h modified +1 −1
src/include/catalog/pg_authid.h modified +12 −22
src/include/catalog/pg_proc.h modified +13 −0
src/include/nodes/parsenodes.h modified +1 −27
src/include/utils/acl.h modified +5 −9
src/include/utils/builtins.h modified +6 −0
src/test/regress/expected/rules.out modified +14 −14