All,
I have attached a patch that addresses the current suggestions and recommendations:
* Add 'get_all_role_attributes' SQL function - returns a text array representation of the attributes from a value passed to it.
Example:
postgres=# SELECT rolname, get_all_role_attributes(rolattr) AS rolattr FROM pg_authid;
rolname | rolattr
----------+-----------------------------------------------------------------------------------------------
postgres | {Superuser,Inherit,"Create Role","Create DB","Catalog Update",Login,Replication,"Bypass RLS"}
(1 row)
* Refactor #define's from 'parsenodes.h' to 'acl.h'
* Added #define ROLE_ATTR_ALL to represent all currently available attributes.
* Added
genbki.pl substitution for PGROLEATTRALL constant.