Greetings, The question of removing the pre-role, deprecated, views of pg_user, pg_group and pg_shadow has come up again.
I figured a new thread was in order, however, to allow others to weigh in on it. Note that these views have not been consistently maintained and have ended up including some role attributes from recent versions (eg: bypassrls) but were missed when others were added (eg: createrole). There are properly maintained and cared for role-based versions of all of these views, which are pg_roles, pg_auth_members, and pg_authid, respectively. As we move forward with the other many changes in PG10, it seems like a good time to remove these inconsistent and ancient views that were introduced when roles were added in 2005. Thanks! Stephen
Description: Digital signature