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

help / color / mirror / Atom feed
From: Peter Eisentraut <peter@eisentraut.org>
To: Erki Eessaar <erki.eessaar@taltech.ee>
To: pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
Subject: Re: INFORMATION_SCHEMA.routine_column_usage
Date: Fri, 1 Dec 2023 08:53:50 +0100
Message-ID: <aef389a3-e531-412c-8bf7-52491fe90aa2@eisentraut.org> (raw)
In-Reply-To: <28163ed6-e3aa-49b3-8053-02f6c145f02f@eisentraut.org>
References: <AM9PR01MB8268EC7B696F9FE346CA5B93FEB8A@AM9PR01MB8268.eurprd01.prod.exchangelabs.com>
	<28163ed6-e3aa-49b3-8053-02f6c145f02f@eisentraut.org>

On 29.11.23 15:01, Peter Eisentraut wrote:
>> Here
>> https://www.postgresql.org/docs/current/infoschema-routine-column-usage.html <https://www.postgresql.org/docs/current/infoschema-routine-column-usage.html;
>>
>> it is stated that "The view |routine_column_usage| is meant to 
>> identify all columns that are used by a function or procedure. This 
>> information is currently not tracked by PostgreSQL."
>>
>> However, this claim is incorrect because the view provides information 
>> about the column usage of SQL functions that have SQL-standard 
>> function body.
> 
> Correct, the documentation was not updated when this was added.  A few 
> other views are similarly affected.  How about this attached patch.

Fix committed.






view thread (3+ messages)

Message-ID: <aef389a3-e531-412c-8bf7-52491fe90aa2@eisentraut.org>
Permalink:  ../aef389a3-e531-412c-8bf7-52491fe90aa2@eisentraut.org/
Also on:    postgresql.org/message-id/aef389a3-e531-412c-8bf7-52491fe90aa2@eisentraut.org

 · 

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-docs@postgresql.org
  Cc: peter@eisentraut.org, erki.eessaar@taltech.ee, pgsql-docs@lists.postgresql.org
  Subject: Re: INFORMATION_SCHEMA.routine_column_usage
  In-Reply-To: <aef389a3-e531-412c-8bf7-52491fe90aa2@eisentraut.org>

* 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