Hi Here:
https://www.postgresql.org/docs/12/view-pg-roles.html we state: "This view explicitly exposes the OID column of the underlying table, since that is needed to do joins to other catalogs." I think it's superfluous to mention this now OIDs are exposed by default; attached patch (for REL_12_STABLE and HEAD) simply removes this sentence. Regards Ian Barwick -- Ian Barwick https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml new file mode 100644 index 3428a7c..68ad507 *** a/doc/src/sgml/catalogs.sgml --- b/doc/src/sgml/catalogs.sgml *************** SELECT * FROM pg_locks pl LEFT JOIN pg_p *** 9995,10005 **** that blanks out the password field. </para> - <para> - This view explicitly exposes the OID column of the underlying table, - since that is needed to do joins to other catalogs. - </para> - <table> <title><structname>pg_roles</structname> Columns</title> --- 9995,10000 ----