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 CAKFQuwbjTy8oVn=zCOuETXnnrW3V+tkoSq4o6aLM-fU23kUNpw@mail.gmail.com
Whole thread Raw
In response to 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:55 AM David G. Johnston <david.g.johnston@gmail.com> wrote:
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.


I put this change into v0002 and posted it to -hackers as part of a multi-patch thread.

David J.

pgsql-general by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: autovacuum_freeze_max_age on append-only tables
Next
From: Mladen Gogala
Date:
Subject: Re: Are stored procedures/triggers common in your industry