Commit5fe2d4c

committed

doc: clarify how dropping of extensions affects dependent objs.

Clarify that functions/procedures are dropped when any extension thatdepends on them is dropped.Reported-by: David G. JohnstonDiscussion:https://postgr.es/m/CAKFQuwbPSHMDGkisRUmewopweC1bFvytVqB=a=X4GFg=4ZWxPA@mail.gmail.comBackpatch-through: 13

1 parent47ae694 commit5fe2d4cCopy full SHA for 5fe2d4c

File tree

+16

-7

lines changed

+16

-7

lines changed

Lines changed: 4 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -160,8 +160,10 @@ ALTER FUNCTION <replaceable>name</replaceable> [ ( [ [ <replaceable class="param`
`160`	`160`	`<para>`
`161`	`161`	`This form marks the function as dependent on the extension, or no longer`
`162`	`162`	`dependent on that extension if <literal>NO</literal> is specified.`
`163`		`- A function that's marked as dependent on an extension is automatically`
`164`		`- dropped when the extension is dropped.`
	`163`	`+ A function that's marked as dependent on an extension is dropped when the`
	`164`	`+ extension is dropped, even if <literal>CASCADE</literal> is not specified.`
	`165`	`+ A function can depend upon multiple extensions, and will be dropped when`
	`166`	`+ any one of those extensions is dropped.`
`165`	`167`	`</para>`
`166`	`168`	`</listitem>`
`167`	`169`	`</varlistentry>`

Lines changed: 6 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -147,7 +147,12 @@ ALTER PROCEDURE <replaceable>name</replaceable> [ ( [ [ <replaceable class="para`
`147`	`147`	`<term><replaceable class="parameter">extension_name</replaceable></term>`
`148`	`148`	`<listitem>`
`149`	`149`	`<para>`
`150`		`- The name of the extension that the procedure is to depend on.`
	`150`	`+ This form marks the procedure as dependent on the extension, or no longer`
	`151`	`+ dependent on the extension if <literal>NO</literal> is specified.`
	`152`	`+ A procedure that's marked as dependent on an extension is dropped when the`
	`153`	`+ extension is dropped, even if cascade is not specified.`
	`154`	`+ A procedure can depend upon multiple extensions, and will be dropped when`
	`155`	`+ any one of those extensions is dropped.`
`151`	`156`	`</para>`
`152`	`157`	`</listitem>`
`153`	`158`	`</varlistentry>`

Lines changed: 6 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -30,7 +30,9 @@ DROP EXTENSION [ IF EXISTS ] <replaceable class="parameter">name</replaceable> [`
`30`	`30`
`31`	`31`	`<para>`
`32`	`32`	`<command>DROP EXTENSION</command> removes extensions from the database.`
`33`		`- Dropping an extension causes its component objects to be dropped as well.`
	`33`	`+ Dropping an extension causes its component objects, and other explicitly`
	`34`	`+ dependent routines (see <xref linkend="sql-alterroutine"/>,`
	`35`	`+ the depends on extension action), to be dropped as well.`
`34`	`36`	`</para>`
`35`	`37`
`36`	`38`	`<para>`
`@@ -77,9 +79,9 @@ DROP EXTENSION [ IF EXISTS ] <replaceable class="parameter">name</replaceable> [`
`77`	`79`	`<term><literal>RESTRICT</literal></term>`
`78`	`80`	`<listitem>`
`79`	`81`	`<para>`
`80`		`-Refuse to drop theextension if any objects depend on it (other than`
`81`		`-its ownmember objectsand other extensions listed in the same`
`82`		`-<command>DROP</command> command). This is the default.`
	`82`	`+This option prevents thespecified extensions from being dropped`
	`83`	`+if there exists non-extension-member objectsthat depends on any`
	`84`	`+the extensions. This is the default.`
`83`	`85`	`</para>`
`84`	`86`	`</listitem>`
`85`	`87`	`</varlistentry>`

Comments

(0)