pgsql: Routine usage information schema tables

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(-)

Browse pgsql-committers by date

  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