| 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-11-29 14:01:00 |
| Message-ID: | 28163ed6-e3aa-49b3-8053-02f6c145f02f@eisentraut.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
> 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.
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-doc-Update-info-on-information-schema-usage-tables.patch | text/plain | 3.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eric Hanson | 2023-11-29 14:10:29 | Re: "name" vs "alias" in datatype table |
| Previous Message | Peter Eisentraut | 2023-11-29 13:40:19 | Re: "name" vs "alias" in datatype table |