pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Ian Barwick <ian.barwick@2ndquadrant.com>
To: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
Subject: doc: minor update for description of "pg_roles" view
Date: Wed, 10 Jul 2019 14:35:56 +0900
Message-ID: <b6ec6167-5dd5-6347-ac1d-1fd49382019f@2ndquadrant.com> (raw)

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

Attachments:


view-pg_roles.v1.patch (text/x-patch, 565B) download
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 ----

view thread (3+ messages)  latest in thread

Message-ID: <b6ec6167-5dd5-6347-ac1d-1fd49382019f@2ndquadrant.com>
Permalink:  ../b6ec6167-5dd5-6347-ac1d-1fd49382019f@2ndquadrant.com/
Also on:    postgresql.org/message-id/b6ec6167-5dd5-6347-ac1d-1fd49382019f@2ndquadrant.com

 ·  · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: ian.barwick@2ndquadrant.com
  Subject: Re: doc: minor update for description of "pg_roles" view
  In-Reply-To: <b6ec6167-5dd5-6347-ac1d-1fd49382019f@2ndquadrant.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox