Routine usage information schema tables

Started by Peter Eisentrautabout 5 years ago2 messageshackers
Jump to latest
#1Peter Eisentraut
peter_e@gmx.net

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.

I developed this as part of the patch "SQL-standard function body",
where it would become more useful, but I'm sending it now separately to
not bloat the other patch further.

[0]: /messages/by-id/1c11f1eb-f00c-43b7-799d-2d44132c02d7@2ndquadrant.com
/messages/by-id/1c11f1eb-f00c-43b7-799d-2d44132c02d7@2ndquadrant.com

Attachments:

0001-Routine-usage-information-schema-tables.patchtext/plain; charset=UTF-8; name=0001-Routine-usage-information-schema-tables.patch; x-mac-creator=0; x-mac-type=0Download+602-2
#2Erik Rijkers
er@xs4all.nl
In reply to: Peter Eisentraut (#1)
Re: Routine usage information schema tables

On 02/09/2021 3:06 PM Peter Eisentraut <peter.eisentraut@enterprisedb.com> wrote:

Several information schema views track dependencies between
functions/procedures and objects used by them. These had not been

[0001-Routine-usage-information-schema-tables.patch]

Spotted one typo:

included here ony if
included here only if

Erik Rijkers