Re: INFORMATION_SCHEMA.routine_column_usage

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: Erki Eessaar <erki(dot)eessaar(at)taltech(dot)ee>, "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re: INFORMATION_SCHEMA.routine_column_usage
Date: 2023-12-01 07:53:50
Message-ID: aef389a3-e531-412c-8bf7-52491fe90aa2@eisentraut.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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.

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message David Virebayre 2023-12-01 12:08:15 Re: Clarification regarding CREATE TABLE LIKE and FOREIGN KEYS
Previous Message Michael Paquier 2023-12-01 07:01:24 Re: Delete description of trigger file