Re: [HACKERS] [PATCH] Rename pg_switch_xlog to pg_switch_wal

* Andres Freund (andres@anarazel.de) wrote:
> On 2017-02-09 19:19:21 -0500, Stephen Frost wrote:
> > I'd love to nuke pg_shadow and all the other
> > not-really-maintained backwards-compat things from when roles were
> > added too.
>
> Not sure if it's worth the work to rip out and such, but I'm mildly
> supportive of this one too.  Depends a bit on what all the other things
> are ;)

Reviewing 7762619e95272974f90a38d8d85aafbe0e94add5 where roles were
added, I find:

pg_user   - use pg_roles instead, which actually includes all of the role           attributes, unlike pg_user

pg_shadow - use pg_authid instead, which, again, actually includes all           of the role attributes, unlike
pg_shadow.

pg_group  - use pg_auth_members instead, which includes the info about           the admin option and the grantor

I don't think we should remove things like CREATE USER, that's a
perfectly reasonable and maintained interface, unlike the above views,
which missed out on things like the 'createrole' role attribute.

Thanks!

Stephen