Re: alter function/procedure depends on extension - Mailing list pgsql-general

From David G. Johnston
Subject Re: alter function/procedure depends on extension
Date
Msg-id CAKFQuwb_QtY25feLeh=8uNdnyo1H=cN4R3vENsUwQzJP4-0xZg@mail.gmail.com
Whole thread Raw
In response to Re: alter function/procedure depends on extension  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: alter function/procedure depends on extension  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
On Tue, Apr 12, 2022 at 8:49 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> -      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 skipped during
> +      dependency checking in restrict mode <xref linkend="sql-dropextension"/>.

That is absolutely not an improvement.  The proposed replacement text
is about as clear as mud.

+ A function that's marked as dependent on an extension is dropped when the extension is dropped, even if cascade is not specified.

I suppose that is a wordier way to say "automatically" but referencing the actual command keyword seems beneficial.

David J.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: alter function/procedure depends on extension
Next
From: Jerry Sievers
Date:
Subject: Feedback about hybrid SAN snap and rsync'd approach for large systemcloning