From: | Peter Eisentraut <peter(at)eisentraut(dot)org> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: Routine usage information schema tables |
Date: | 2021-02-17 17:19:00 |
Message-ID: | E1lCQTc-0003dn-AQ@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Routine usage information schema tables
Several information schema views track dependencies between
functions/procedures and objects used by them. These had not been
implemented so far because PostgreSQL doesn't track objects used in a
function body. However, formally, these also show dependencies used
in parameter default expressions, which PostgreSQL does support and
track. So for the sake of completeness, we might as well add these.
If dependency tracking for function bodies is ever implemented, these
views will automatically work correctly.
Reviewed-by: Erik Rijkers <er(at)xs4all(dot)nl>
Discussion: https://www.postgresql.org/message-id/flat/ac80fc74-e387-8950-9a31-2560778fc1e3%40enterprisedb.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/f40c6969d0eddfc6de786006bd1048961a65a0eb
Modified Files
--------------
doc/src/sgml/information_schema.sgml | 443 ++++++++++++++++++++++++
src/backend/catalog/information_schema.sql | 100 +++++-
src/backend/catalog/sql_features.txt | 2 +-
src/include/catalog/catversion.h | 2 +-
src/test/regress/expected/create_function_3.out | 38 ++
src/test/regress/sql/create_function_3.sql | 24 ++
6 files changed, 603 insertions(+), 6 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2021-02-17 17:24:53 | pgsql: Make some minor improvements in the regex code. |
Previous Message | Magnus Hagander | 2021-02-17 12:58:01 | pgsql: Fix typo |