Routine usage information schema tables
authorPeter Eisentraut <peter@eisentraut.org>
Wed, 17 Feb 2021 16:53:18 +0000 (17:53 +0100)
committerPeter Eisentraut <peter@eisentraut.org>
Wed, 17 Feb 2021 17:16:06 +0000 (18:16 +0100)
commitf40c6969d0eddfc6de786006bd1048961a65a0eb
tree587b4d5d2959fc866d0a1b029b1e040624dd8c5a
parenta29f30780f34d7706fcd398dea1d6882d184d17a
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@xs4all.nl>
Discussion: https://www.postgresql.org/message-id/flat/ac80fc74-e387-8950-9a31-2560778fc1e3%40enterprisedb.com
doc/src/sgml/information_schema.sgml
src/backend/catalog/information_schema.sql
src/backend/catalog/sql_features.txt
src/include/catalog/catversion.h
src/test/regress/expected/create_function_3.out
src/test/regress/sql/create_function_3.sql