diff options
| author | Bruce Momjian <bruce@momjian.us> | 2022-07-14 17:41:03 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2022-07-14 17:41:03 -0400 |
| commit | ef9d0cf19cdb74fd9b9f833d8e42ed283e0def23 (patch) | |
| tree | ea9865748b2bcfdc86607bdb9862c72988958ae7 /doc/src/sgml/ref/alter_function.sgml | |
| parent | 2d4c6437c87e6a036a163b1b4363097ee860cef0 (diff) | |
doc: clarify how dropping of extensions affects dependent objs.
Clarify that functions/procedures are dropped when any extension that
depends on them is dropped.
Reported-by: David G. Johnston
Discussion: https://postgr.es/m/CAKFQuwbPSHMDGkisRUmewopweC1bFvytVqB=a=X4GFg=4ZWxPA@mail.gmail.com
Backpatch-through: 13
Diffstat (limited to 'doc/src/sgml/ref/alter_function.sgml')
| -rw-r--r-- | doc/src/sgml/ref/alter_function.sgml | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/alter_function.sgml b/doc/src/sgml/ref/alter_function.sgml index c5d12af25cd..f64940b7319 100644 --- a/doc/src/sgml/ref/alter_function.sgml +++ b/doc/src/sgml/ref/alter_function.sgml @@ -160,8 +160,10 @@ ALTER FUNCTION <replaceable>name</replaceable> [ ( [ [ <replaceable class="param <para> This form marks the function as dependent on the extension, or no longer dependent on that extension if <literal>NO</literal> is specified. - A function that's marked as dependent on an extension is automatically - dropped when the extension is dropped. + A function that's marked as dependent on an extension is dropped when the + extension is dropped, even if <literal>CASCADE</literal> is not specified. + A function can depend upon multiple extensions, and will be dropped when + any one of those extensions is dropped. </para> </listitem> </varlistentry> |